Solved

# Excel "clone"

Posted on 2005-03-21
Medium Priority
257 Views
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
0
Question by:cozmo_troll
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 22

Accepted Solution

Dreamboat earned 2000 total points
ID: 13597155
You need the Wizard.
(Snorts through nose)

Open Mother Workbook.
Open 3 workbooks.
Copy cells on sheet from workbook1.
Go to Mother. Edit-Paste special, Paste Links.
Do the same for workbooks 2 and 3.

Problem? Yes....

If the number of rows varies, this is a PITA!
You will end up with lots of rows that contain 0 because the rows on the baby sheets contain blank cells.
0

Expert Comment

ID: 13599311
1. Open Workbooks A, B, C & D
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...

0

LVL 22

Expert Comment

ID: 13600769
Thanks!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month14 days, 18 hours left to enroll