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.


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.

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