Valentinas
09-09-2010, 11:20 PM
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 :)
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 :)