| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Same formula on multiple sheets
How can I get the total of a specific formula on worksheet 1 to be on
worksheet 2 as well? I hope the question makes sense. Thank you in advance for the help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Same formula on multiple sheets
If you mean what you seem to mean - that (for example) Sheet1!$B$43 has the
formula =SUM(B$2:B42), which displays 12,345, and you want to display the result 12,345 on Sheet2!$C$5, then on Sheet2 in cell C5 you simply put the formula =Sheet1!$B$43. Whenever the sum changes, the value displayed on Sheet2 changes too. But maybe you meant something more complicated than that. --- "onebodaciousbabe03" wrote: How can I get the total of a specific formula on worksheet 1 to be on worksheet 2 as well? I hope the question makes sense. Thank you in advance for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linked formula on multiple sheets | Excel Worksheet Functions | |||
| Formula across multiple sheets | Excel Worksheet Functions | |||
| IF formula over multiple sheets | Excel Discussion (Misc queries) | |||
| formula to add up on multiple sheets | Excel Worksheet Functions | |||
| How can i use data from multiple sheets in a formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
