Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Should be able to name Excel sheets based on cells in workbook | Excel Discussion (Misc queries) | |||
I can I set up Excel to print all sheets of a workbook as a defau. | Excel Discussion (Misc queries) | |||
How do I link sorted data to other workbook sheets? | Excel Worksheet Functions | |||
How do Icreate link from page of contents to sheets in workbook? | Excel Discussion (Misc queries) |