Open list file and copy sheet

[matrix_xrs]

Hi,

i'm hoping someone here can give me some directions with a macro i'm trying to create

I'm trying to create a macro that will look at a list of files open the first one and then search the sheet names and if the sheet names matches the file name copy the sheet to the opened file.

example:

file 1:
sheet1 Contains a list of file name and path
sheet2: apple
Sheet3: banana
Sheet4: car


macro will open first file in list and lets assume it is called apple.xlsx

it will open file and then search file 1 sheet name and if there is a sheet called apple it will copy the sheet to the opened file.


it will continue doing this until the list is complete

fairly new to macro and need some directions as to how to complete this. any help is greatly appreciated

attached a file for sample

thanks a million

[patel45]

Are the sheets apple, car ... already existing in the masterfile ? it would be better no existing.

[matrix_xrs]

Hi Patel45,

yes, the masterfile will have all the sheets apple, car....

my goal is to have it open the list of file one by one and then if one of the sheet name in the masterfile matches the file name to copy that sheet and paste

[patel45]

1) read file name from cell C3 and path from cell D3 C:\Users\Desktop\apple.xlsx
2) open C:\Users\Desktop\apple.xlsx
3) copy sheet apple from MasterSheet
4) paste in C:\Users\Desktop\apple.xlsx

is it correct ?

[matrix_xrs]

Hi Patel45,

yes, that is correct.

do you know of any macro that can do this?

I appreciate your help.

[patel45]

Please Login or Register  to view this content.