I am looking for the answer to a similar problem. I have a calendar
format on sheet1 and there are 5 rows in each date section and those
rows correspond to peoples names which are listed in the farmost left
colum of the spreadsheet. On sheet2 there is a data table with column 1
= date column 2 = person column 3 = location.

The idea here is to return on a calendar where each person will be on a
given day by referencing a table. Any help?


+-------------------------------------------------------------------+
|Filename: MR Revenue.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4091 |
+-------------------------------------------------------------------+

--
MrvinGover
------------------------------------------------------------------------
MrvinGover's Profile: http://www.excelforum.com/member.php...fo&userid=5124
View this thread: http://www.excelforum.com/showthread...hreadid=490074