| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
populating seperate worksheets from master
I have a master worksheet that I want to set it to seperatedata to the
different worksheets so that if q change on the master happens then it will automatically populate the seperate worksheets.? ex: Master worksheet has all information related to students: name, grade, teacher. Then I have seperate sheets for each teacher to see only their class information- If I make a change on the master - I want it to make the change on the corresponding teachers sheet. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
populating seperate worksheets from master
I believe you cannot "push" changes to the other worksheets. You'll need to
set up each teacher's worksheet to "pull" or lookup data from the Master ... that way, you'll only need to update the Master later on. "deb" wrote: I have a master worksheet that I want to set it to seperatedata to the different worksheets so that if q change on the master happens then it will automatically populate the seperate worksheets.? ex: Master worksheet has all information related to students: name, grade, teacher. Then I have seperate sheets for each teacher to see only their class information- If I make a change on the master - I want it to make the change on the corresponding teachers sheet. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| populating a master worksheet with variables in other worksheets | Excel Worksheet Functions | |||
| Populating one worksheet with all lines from other worksheets | Excel Worksheet Functions | |||
| Master spread sheet to manage then show info on seperate tabs | Excel Worksheet Functions | |||
| How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
| Auto Populating cells from a master spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
