populating seperate worksheets from master

[deb]

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

 

[JayPee]

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.