copy data from multiple worksheets into master workbook

Hi there,
I've seen this sort of answered on an old closed thread but i'm hoping someone can help me some with code.
I wish to have a 'master.xlsx' which whe I run a macro, allows me to search and open another workbook 'Entry.xlsx'. The Entry workbook has a number of tabs 'data1', 'data2' that I wish to copy and paste from eache sheet and add to the 'master.xlsx'. The master has the same tabs 'data1' etc. The macro should be able to add data (it's basically compliling 'entry' sheets after every month so the master has the full year data).

hope someone can help. The following code, opens the workbook, but does not copy the data??

hope someone can help

Please Login or Register  to view this content.

Should the data from Entry.xlsx - data1 be copied to the master file data1, and entry.xlsx - data2 be copied to data2, etc?

Try this code

Please Login or Register  to view this content.

Put it in a standard module.

It will be good if you attach the file that you are using along with the code. Even a sample file with dummy data will do.

The code worked fine at my end. Did you put the code into the Master file? If you dont, you will get the error that you got above.

In the master file,
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.

You can declare it as long.
Glad it worked.