Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seperate worksheets
I heard that you can add information in one worksheet and certain parts of
that same information can automaticaly be added to another worksheet within that same workbook. I have a money record that I am putting together. I have about 5 different worksheets. When I add information (such as deposits) on the check book register worksheet, I would like to have it added to the deposit worksheets. Doing this will allow me to seperate and organize certain information. Can anyone help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Seperate worksheets
See Excel help on "linking"
You can link cells from one sheet to another so's an update on source will change destination also. Gord Dibben MS Excel MVP On Wed, 13 Aug 2008 15:49:00 -0700, Justme wrote: I heard that you can add information in one worksheet and certain parts of that same information can automaticaly be added to another worksheet within that same workbook. I have a money record that I am putting together. I have about 5 different worksheets. When I add information (such as deposits) on the check book register worksheet, I would like to have it added to the deposit worksheets. Doing this will allow me to seperate and organize certain information. Can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save worksheets as seperate files (I know how to do it one by one) | Excel Discussion (Misc queries) | |||
Totaling from seperate worksheets | Excel Worksheet Functions | |||
create total from 4 seperate worksheets | Excel Discussion (Misc queries) | |||
How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
Trouble with Dates between 2 seperate worksheets | Excel Discussion (Misc queries) |