ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to carry Excel balance on 1 w/s to another? (https://www.excelbanter.com/excel-worksheet-functions/260004-how-carry-excel-balance-1-w-s-another.html)

SamZ

How to carry Excel balance on 1 w/s to another?
 
I am looking to carry a balance on one worksheet to the next. I know that the
$ is used but cannot find the format.

John[_22_]

How to carry Excel balance on 1 w/s to another?
 
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
"SamZ" wrote in message
...
I am looking to carry a balance on one worksheet to the next. I know that the
$ is used but cannot find the format.




All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com