![]() |
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! |
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! |
All times are GMT +1. The time now is 01:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com