how can i link sheets in my excel workbook
 

i am only new at working with excel. I would like to know how to link sheets
in my work book so that when information is entered in on the master sheet
all relevent information is automatically posted on to the sheets that have
those parameters on them. I am using a workbook that has 3 sheets in it.I
have a members master list, a members financial list and a partially paid
list. I would like to be able to get it so that if the masters list is
updated the others are updated automatically

Hi
though possible for smaller lists with array formulas this becomes very slow
with 100 records. Why not use a filter on the first sheet?. Would be easier

--
Regards
Frank Kabel
Frankfurt, Germany
"new secretary" <new schrieb im
Newsbeitrag ...
i am only new at working with excel. I would like to know how to link
sheets
in my work book so that when information is entered in on the master sheet
all relevent information is automatically posted on to the sheets that
have
those parameters on them. I am using a workbook that has 3 sheets in it.I
have a members master list, a members financial list and a partially paid
list. I would like to be able to get it so that if the masters list is
updated the others are updated automatically