Hello, I desperately need help here.
i have been asked to complete a task that involves copying files with 5 sheets ( around 10 files within folder) to another folder and vlookup from different set of files some data (all file names within folder and sheet names are identical) just exactly same number of sheets and files but different values. Is it possible to perform vlookups including file name and sheet name as well.
For example
1. Folder 1 has 20 files with 5 sheets each.
2. I am duplicating all these and going to run vlookup from different set that has different value.
Is there anyway i possibly combine vlookup values/file names/sheet names in one go instead of running look up 5 times just to complete one file? Any faster routes recommended is helpful.
thanks in advance. M
i have been asked to complete a task that involves copying files with 5 sheets ( around 10 files within folder) to another folder and vlookup from different set of files some data (all file names within folder and sheet names are identical) just exactly same number of sheets and files but different values. Is it possible to perform vlookups including file name and sheet name as well.
For example
1. Folder 1 has 20 files with 5 sheets each.
2. I am duplicating all these and going to run vlookup from different set that has different value.
Is there anyway i possibly combine vlookup values/file names/sheet names in one go instead of running look up 5 times just to complete one file? Any faster routes recommended is helpful.
thanks in advance. M
