-
Merge workbooks sheets
Helo, I have one problem.
I have 3 workbook, with same same sheets names.
Example:
Workbook1: sheet1, sheet2, sheet3
Workbook2: sheet1, sheet2, sheet3
Workbook3: sheet1, sheet2, sheet3
In the all sheet1 is same columns name, but different data.
Name, Surname, Password and etc.
Data1, Data2, Data3
Sheet1 from other workbook example:
Name, Surname, Password and etc.
Data11, Data22, Data33
Question:
How merge the Workbook1, workbook2, Workbook3 to master Workbook, ant merge sheets1 and etc. from all workbook in the Master workbook one sheet.
Finish result:
One workbook, the 3 sheet, this merge data.
Name, Surname, Password
Data1, Data2, Data3
Data11, Data22, Data33
I hope to understand
-
vbaexpress.com/kb/getarticle.php?kb_id=773 is best script, but merge all sheet in the one sheet, i want to all sheet1 merge to sheet1, all sheet2 to sheet2 ant etc
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules