how can i link sheets in my excel workbook

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dividing Data between sheets in a workbook 1
Merge Multiple workbook sheets into one workbook 0
Excel, assign cells in multiple worksheets from one sheet 1
Transferring data from multiple sheets in workbook to one sheet 5
copy an exact formula without changing cell reference 1
how can i link sheets in my excel workbook 3
Save all sheets in a new workbook 7
Linking 3 closed worksheets to master workbook template 1

Top