Greetings.
Here is a problem I am trying to solve. I have some test cases that can be
run on different platforms defined in a spreadsheet. I would like to keep
the master that has everything, then create an individual spreadsheet for
each platform. Here is some example data from the master (simplified data)

Test ID Summary WindowsXP Vista Linux Other
Test1 Open File x x
Test2 Close File x x x
Test3 Use ls x x
Test4 Delete File x x x x

I would like to create 4 additional sheets with ONLY the data for the
platform specified. So the WindowsXP would show

Test1 Open File x
Test2 Close File x
Test4 Delete File x

I can get it to 'kinda' work using an advanced filter. However if I make a
change to the master, I need to have the change update all the others if it
applies. The list is dynamic, and changes frequently. I know I could just
rerun the advanced filter, but am hoping for a better solution. I haven't
done much macro code in excel, but am willing to take a shot if needed.
Thanks in advance for all your ideas.