How to carry Excel balance on 1 w/s to another?

S

SamZ

I am looking to carry a balance on one worksheet to the next. I know that the
$ is used but cannot find the format.
 
J

John

Hi Sam
I'm not sure what you want but this formula =Sheet1!B20
typed in an other sheet anywhere will bring the information from Sheet1 cell
B20.
You need to change the variable to your needs.
HTH
John
 

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

Carry over YTD balance to next worksheet 4
Closing Balance figure to be carried as Opening Balance in a new record 0
Closing Balance figure to be carried as Opening Balance in a new record 1
Running balance for debit and Credit using query in Access 2007 0
2007 and running balance across worksheets 0
Help with a running total on multiple sheets 2
Check register running balance to another worksheet 1
Auto Sum not working correctly 1

Top