Same formula on multiple sheets

O

onebodaciousbabe03

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!
 
B

Bob Bridges

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Embed the same Excel multiple times 0
comparing sheet to sheet and adding value 1
Macro to select and delete levels of a document 2
Help with a running total on multiple sheets 2
Need help with average/lookup formula 2
dragging formula is giving me undesired result in cell calls. 0
Calculate end date and time 1

Top