how can i link sheets in my excel workbook

N

new secretary

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
 
F

Frank Kabel

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
 
Top