Hi Community,
This is my first post!
My goal is to merge multiple sheets in multiple workbooks to create a master sheet in a different workbook.
Example:
WorkBook1Sheet1
A 1 2 3 4
B 5 6 7 8
WorkBook1Sheet2
C 9 10 11 12
D 13 14 15 16
WorkBook2Sheet1
E 17 18 19 20
F 21 22 23 24
WorkBook2Sheet2
G 25 26 27 28
H 29 30 31 32
WorkBook3Master (desired results)
A B 1 2 3 4 5 6 7 8
C D 9 10 11 12 13 14 15 16
E F 17 18 19 20 21 22 23 24
G H 25 26 27 28 29 30 31 32
I am currently merging the data manually, which is very tedious.
Can this be done without a Macro or VBA? If it does, can you suggest where to look for help to create a Macro or write the VBA code or can this be done with an existing tool in MS Excel 2007?
If require any additional information, please post, I will elaborate.
Thank you in advance.
Cheers
Bookmarks