ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Same formula on multiple sheets (https://www.excelbanter.com/excel-worksheet-functions/225227-same-formula-multiple-sheets.html)

onebodaciousbabe03

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!



Bob Bridges[_2_]

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