Seperate worksheets

J

Justme

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?
 
G

Gord Dibben

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
 
Top