Its working well my bad
I used the code in the same file which I have attached...Do I need to remove the H column or keep it as it is??
Getting this error while running the code
Any update on this??
Please find the attachment.
The names of the files are given in column G and suggested names in column H
I have a excel with multiple columns where in column T I have some names with duplicates say A.pdf,B.pdf,C.pdf,A.pdf,A.pdf,A.pdf
I want them on this way using macro code
Any help would be appreciated