excel_puppy
New Member
- Joined
- Feb 5, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
hello,
i have two workbooks (names change, not consistent) with similar sheet names. For example, book1 has sheet1, sheet2 and sheet3 while book2 has sheet1, sheet3, sheet4 and sheet5. each sheet contains data. what i'm looking for is a way to have the same sheets on each workbook. so book1 would have the original sheet1,sheet2 and sheet3 (no changes to the data), and now sheet4 and sheet5 are added (both would be blank, just need the sheet names added). for book2, the original sheet1,sheet3,sheet4 and sheet5 remain untouched while a blank sheet2 is added. so in the end, both workbooks have sheet1,sheet2,sheet3,sheet4 and sheet5 in the same order. the newly added sheets will remain blank in their respective workbook. the reason for this question is so that we can compare the two workbooks and search for differences but for this to work, the sheets need to be identical and in same order. any advice would be greatly appreciated!
i have two workbooks (names change, not consistent) with similar sheet names. For example, book1 has sheet1, sheet2 and sheet3 while book2 has sheet1, sheet3, sheet4 and sheet5. each sheet contains data. what i'm looking for is a way to have the same sheets on each workbook. so book1 would have the original sheet1,sheet2 and sheet3 (no changes to the data), and now sheet4 and sheet5 are added (both would be blank, just need the sheet names added). for book2, the original sheet1,sheet3,sheet4 and sheet5 remain untouched while a blank sheet2 is added. so in the end, both workbooks have sheet1,sheet2,sheet3,sheet4 and sheet5 in the same order. the newly added sheets will remain blank in their respective workbook. the reason for this question is so that we can compare the two workbooks and search for differences but for this to work, the sheets need to be identical and in same order. any advice would be greatly appreciated!