Hello,
So I have 8 files already opened for which I have to copy the data and paste it in 8 tabs. So I have 2 variables, the Files and the Tabs. With the code I'm trying the macro copies the content of each file, but paste it 8 times in the first tab! I tried the loop in another order but it happened something similar, it copied the content of the first file in the 8 tabs. What should I do so the code opens the first file and copies its content to the first tab, second file to the second tab, etc?
I add the code:
Thanks a lot!
Bookmarks