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