Chookz
Board Regular
- Joined
- May 9, 2011
- Messages
- 95
Hey guys,
I have 4 different databases in 4 different workbooks.
I need to create a macro to open each of the 4 workbooks, copy the databases and paste them into 4 separate sheets in my current workbook.
Is anyone able to help me with a VBA code?
Use these assumptions and I'll fill in the correct details.
The 4 workbooks are located on the desktop:
C:\Users\callen\Desktop\Workbook 1
C:\Users\callen\Desktop\Workbook 2
C:\Users\callen\Desktop\Workbook 3
C:\Users\callen\Desktop\Workbook 4
The databases are located in a sheet called RawData in each of the 4 workbooks
This range will select the data in the database to be copied: Range("OFFSET(A1, 0, 0, COUNTA(A1:A50000), 431)").Select
The sheets in my current workbook for the databases to be pasted are called:
DB1
DB2
DB3
DB4
With DB1 corresponding to the database from Workbook 1 etc. The data can be pasted in cell A1
The current workbook is also located on the desktop and is called DatabaseMaster
I think that should be all the details, thanks in advance to anyone who is able to help. This will save me a huge amount of time
Cheers,
I have 4 different databases in 4 different workbooks.
I need to create a macro to open each of the 4 workbooks, copy the databases and paste them into 4 separate sheets in my current workbook.
Is anyone able to help me with a VBA code?
Use these assumptions and I'll fill in the correct details.
The 4 workbooks are located on the desktop:
C:\Users\callen\Desktop\Workbook 1
C:\Users\callen\Desktop\Workbook 2
C:\Users\callen\Desktop\Workbook 3
C:\Users\callen\Desktop\Workbook 4
The databases are located in a sheet called RawData in each of the 4 workbooks
This range will select the data in the database to be copied: Range("OFFSET(A1, 0, 0, COUNTA(A1:A50000), 431)").Select
The sheets in my current workbook for the databases to be pasted are called:
DB1
DB2
DB3
DB4
With DB1 corresponding to the database from Workbook 1 etc. The data can be pasted in cell A1
The current workbook is also located on the desktop and is called DatabaseMaster
I think that should be all the details, thanks in advance to anyone who is able to help. This will save me a huge amount of time
Cheers,