Look in Excel help at the Vlookup function - so that your two dependent
sheets are always drawing information from the master sheet.

--
Regards,
Tom Ogilvy

"New Secretary" <New wrote in message
...
i would like to know how to share information between sheets in an excel
workbook. I currently have 3 sheets that are used regularly, the first is
a
master list, then a current members list and the third is a partially paid
listing. What I would like tp be able to do is enter the info on the
master
sheet and have the other sheets automatically update the relevant cells.
I
would like it to be explained in simple terms as my system is using xp and
I
do not know my way around it yet.

Thanking in anticipation of anyone that answer my query