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?

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?