How to copy data to another file loop?

[elmnas]

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.