Excel "clone"

Posted on 2005-03-21
Medium Priority
Last Modified: 2012-08-14
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?

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.

Question by:cozmo_troll
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
  • Learn & ask questions
  • 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.

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...

LVL 22

Expert Comment

ID: 13600769

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

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…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question