How do I duplicate spreadsheets on same worksheet and keep formula's?

[domgilberto]

Hey

I have three tabs in an excel worksheet.

They have formula's that interact with each other.

How can I copy these tabs to make a duplicate within the same worksheet, BUT make the formula's work independtly within the NEW three tabs... So it's like having 2x 3 tabs?


Hope this makes sense?

[aydeegee]

This method is "cludgey" but it works

Save original workbook (WB1) with whatever names you already have say Sheet1, Sheet2 and Sheet3
Save as WB2 and rename Sheet1 to Sheet4, Sheet2 to Sheet5,Sheet3 to Sheet6.
Open WB1. Insert new 3 sheets and rename (if necessary) to Sheet4 /5 /6)
Select 3 pages of WB2
Select all rows and columns
Copy
Paste into WB1 Sheet4 cell A1

It is embarrasingly cumbersome, but it get the job done

(Don't do it on "live" unsaved data!)

Let me know if it does what you want

Regards

Alastair

[Tank997]

Have you tried right clicking on the sheet tab and clicking "Move or Copy" then checking the "Create a copy" check box? This should make an exact copy of your sheet as Sheet1(1).