Hello All
In this excel file i want to loop through column G and on the basis of the current value i have to find that path in column D.
After that i have to copy the complete path and write into the H column based on G column index.
For Example:-
my current value is 57862542_120661102. I will search in D Column where it will match.I will copy the complete path C:\Bot\Downloads\xmls\Z57862542_AE1_000120661102_0073.xml And write into the XML_File_Path column in first row.
Plz tell me any solution.
Thanks in Advance