cozmo_troll
asked on
Excel "clone"
I currently have 3 separate workbooks including 1 worksheet each. Is there a way to create one workbook that contains 3 worksheets that would be a clone of the individual 3 sheets?
Example:
Workbook A = Sheet: Bears
Workbook B = Sheet: Lions
Workbook C = Sheet: Tigers
What I want is for Workbook D to include 3 sheets: Bears, Lions, Tigers
And, these 3 sheets will automatically be updated by the original 3 workbooks.
Thanks
Example:
Workbook A = Sheet: Bears
Workbook B = Sheet: Lions
Workbook C = Sheet: Tigers
What I want is for Workbook D to include 3 sheets: Bears, Lions, Tigers
And, these 3 sheets will automatically be updated by the original 3 workbooks.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks!
2. From Workbook D-Bear-A1 cell, type '='
3. Switch to Workbook A (Bear)
4. Select A1 then press 'Enter'
You will be brought back to Workbook D-Bear-A1 cell with the following formula: '=<Workbook A>.xls!$A$1'
5. Remove '$' from cell A1 formula
6. 'Copy' cell A1
7. Block cells covering your required cells
8. Click 'Paste'; this will copy A1 cell formula with respect to row & collumn references on Workbook A
Perform the same steps (2-8) for Workbook D-Lion & Tiger. You may also want to add Worksheet protection to Workbook D afterwards.
Hope this helps...