Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Worksheet | Excel Discussion (Misc queries) | |||
Excel: Relative worksheet references? | Excel Discussion (Misc queries) | |||
Worksheet 1 exact copy of worksheet 2, but in different order | Excel Discussion (Misc queries) | |||
Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions |