Redirect formulas to a new sheet in workbook

[PA]

I have an Excel file, ver 2002. Two worksheets of interest for me are named
5005 PH1 and PSIE PH1. 5005 PH1 contains actual budget values hand keyed by
the users. PSIE PH1 contain formulas/functions that are pointing to cells in
5005 PH1. There are a lot of formulas.
I now find I need to create new sheets, copies of the two above referenced
sheet, but they will be renamed 5005 PH2 and PSIE PH2. 5005 PH2 will contain
newly hand keyed values. I need to redirect the formulas in PSIE PH2 to pull
in values from 5005 PH2, rather than 5005 PH1.
Is there a simple way to do this, short of re-doing each formula manually.
THis will be a major undertaking.
Thank you for any guidance.
Paul

 

[Gilles Desjardins]

Hi PAul,

Click on the two sheet TABS (they become white), right mouse click the TABS.
Use the copy command (don't forget the check mark in the box). VOILA! DONE!
Just delete the old Data in the sheet labelled XXX(2)

HTH

Gilles