Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Redirect formulas to a new sheet in workbook
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Redirect formulas to a new sheet in workbook
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 "PA" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change sheet reference in new workbook | Excel Discussion (Misc queries) | |||
Aways open workbook on sheet 1 ??? | Excel Discussion (Misc queries) | |||
Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) |