Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apply fomulas to additional worksheets as added
Good morning,
Is there an easy way to apply formulas to additional worsheets as they are added, e.g. take all formulas on SheetA that calculate data on SheetB, and make the formulas now point and calculate data on sheetC (if worksheet is in same format and placement)? For instance, If I build a worksheet (on Sheet2) that has numerous formulas to conduct calculations on Sheet3, then if I import a download data from an online source into Sheet4 (in the same format as sheet3), is there an easy way to make all the formulas in my Sheet2 now calculate Sheet4 data? Thanks, Any suggestions are greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apply fomulas to additional worksheets as added
You can use replace, from the Edit menu. In the "Find what:" box type the
old worksheet name, and in the "Replace with:" type the new worksheet name. Hope this helps, Miguel. "Brent E" wrote: Good morning, Is there an easy way to apply formulas to additional worsheets as they are added, e.g. take all formulas on SheetA that calculate data on SheetB, and make the formulas now point and calculate data on sheetC (if worksheet is in same format and placement)? For instance, If I build a worksheet (on Sheet2) that has numerous formulas to conduct calculations on Sheet3, then if I import a download data from an online source into Sheet4 (in the same format as sheet3), is there an easy way to make all the formulas in my Sheet2 now calculate Sheet4 data? Thanks, Any suggestions are greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apply fomulas to additional worksheets as added
Thanks, Miguel.
"Miguel Zapico" wrote: You can use replace, from the Edit menu. In the "Find what:" box type the old worksheet name, and in the "Replace with:" type the new worksheet name. Hope this helps, Miguel. "Brent E" wrote: Good morning, Is there an easy way to apply formulas to additional worsheets as they are added, e.g. take all formulas on SheetA that calculate data on SheetB, and make the formulas now point and calculate data on sheetC (if worksheet is in same format and placement)? For instance, If I build a worksheet (on Sheet2) that has numerous formulas to conduct calculations on Sheet3, then if I import a download data from an online source into Sheet4 (in the same format as sheet3), is there an easy way to make all the formulas in my Sheet2 now calculate Sheet4 data? Thanks, Any suggestions are greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update consolidated sheet when data is added to worksheets | Excel Discussion (Misc queries) | |||
'Correct' way for multiple calculation from other worksheets? | Excel Discussion (Misc queries) | |||
Is it possible to permanently group worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Filter list on additional worksheets | Excel Discussion (Misc queries) |