Hi guys,


I Have got like hundreds of files.

one example of the filename can be:

test_A.xlsx

that contains data in Column A

I have also got a file with name:

test_A_sv.xlsx


that contains data in Column B


How do I put the Column B from the file:

Test_A_sv.xlsx in the file:
test_a.xlsx in Column B?



the other files can have these name example
(can almost have any name but its still like pair

xxxxx_xxxxx_xx_xxx.xlsx
xxxxx_xxxxx_xx_xxx_sv.xlsx

xxx_xxxx_xxx_xxxxxxx_xxx.xlsx
xxx_xxxx_xxx_xxxxxxx_xxx_sv.xlsx


also doing that with all other files in the folder?


Thank you in advance.

Hi,

From what you are showing to me it would be very difficult to do.
Can you not create a different file and then have the file you want to copy populate the new file? If the file you are looking at contains the "sv" have it go to column "B" otherwise the other file goes to column "A". But, if the files have more than 1 variable this would be almost impossible to do.

as long it result to the same result.

Could you help me ?

Thank you in advance.

Hi,

Can you give us a more definite naming of your files?
And too which is for column A and B?

I do upload a file as example.

see your private message.

Sending files and seeking solutions by PM is not really what a public forum is about...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you sir