Hi,
I have a file with a number of spreadsheets. I have a master spreadsheet
with all the information I need on it, regarding personnel, their department,
what team they are in etc. I have approximately 250 names and their
corresponding information. What I need to do is have a separate spreadsheet
for different information, eg who belongs to a specific department on one
spreadsheet, and to another department on another spreadsheet. Or one team,
say Team A, on one sheet and another on a separate spreadsheet, say for Team
B.

I know how to do the links using autofilter and the paste link function, but
is there any way I can set up the worksheets to adapt to changing information
in the master document? For example when a person changes departments I don't
want them on the old designated sheet, I want their information to change
across to their new departments spreadsheet. Or if a person changes from Team
A to Team B and I alter the master document then how do I get the information
to automatically delete from the Team A sheet in the file and now appear on
the Team B worksheet where he now belongs?

I am an excel novice so if anyone could be kind enough to help me that would
be great. I can't post the document because it contains confidential
information. Is there a formula or any function that I can do to get what I
want.

Thanks,
Jo