I ran into a small problem. I have sheet 1 with staff listed
alphabetically and sheet 2 with staff listed by shift platoon (4 groups
of 7 people each). How do I arrange it so that changes I make on sheet
1 will also appear on sheet 2.

I know there is a way to do this because I found a partial answer on
google, but the problem is that what is in cell C4 in sheet 1 is not
the same as what is in cell C4 in sheet 2 and so on and so on. Both
sheets have the same info but it is all arranged differently.

Is it possible to solve my problem without having to enter the data
twice? (once on sheet 1 and then again on sheet 2).

Thanks!


--
IcarusFB
------------------------------------------------------------------------
IcarusFB's Profile: http://www.excelforum.com/member.php...o&userid=29905
View this thread: http://www.excelforum.com/showthread...hreadid=496102