HOW DO I GET A BALANCE TO C/FORWARD TO NEXT WORKSHEET
I know how to set up a balance sheet but would like to carry forward some
information to the next worksheet but without using copy - almost like an automatic update. When i type in one cell it will automatically update in another cell on the next worksheet. hope you can help. |
HOW DO I GET A BALANCE TO C/FORWARD TO NEXT WORKSHEET
What you need to do is this:
1) go on the next worksheet where you want the carried forward information to be 2) type = and then go and select the cell on the previous worksheet where the information comes from. You will end up with something like this in the new sheet =OldSheet!A1 -- Allllen "zhandra" wrote: I know how to set up a balance sheet but would like to carry forward some information to the next worksheet but without using copy - almost like an automatic update. When i type in one cell it will automatically update in another cell on the next worksheet. hope you can help. |
All times are GMT +1. The time now is 03:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com