Basically I am setting up a scheduling system using excel. I have
thought about using access but the main function of this system is for
it to be visually communicative.

I am scheduling for for designers in different territories... I want to
be able to schedule these designers by territory and by the master
sheet, the problem is, is that all the designers have 2 territories
they service and they are all different.

My idea was to set up a master sheet with all the designers information
so that I can look at the data that way, and I also wanted to set up
sheets per territory that would also display the same schedule for the
designer just in a less visually complex way.

So say I have 5 territories and 20 designers. I want 6 sheets, 1
master and one for each territory.

I want to be able to enter information in any of the fields per
designer whether that designer services 1-3 territories.... so
basically I want to be able to schedule someone in 3 or more different
cells on different sheets but have them all linked together.

Is this possible and can someone give me some advice as to how I would
do this?

-Shaun


--
shaunvfx
------------------------------------------------------------------------
shaunvfx's Profile: http://www.excelforum.com/member.php...o&userid=26896
View this thread: http://www.excelforum.com/showthread...hreadid=401189