I have a list of people in one table, with a destination for their holiday, and a date ranges next to each one. For instance:
Bill Brown Turkey 01/05/2011 04/05/2011
Bill Brown Sweden 05/06/2011 10/06/2011
John Doe France 07/06/2011 12/06/2011
Bill Brown Australia 09/06/2011 15/06/2011
John Doe Wales 11/06/2011 18/06/2011
What I want is to use this table to populate a second table.
The second table would list all the people down the left hand side, and then have a column for each day with the dates listed along the top.
I want the second table to make the relevant cell turn green when they are on holiday, but red if they are trying to be on two holidays at the same time. That should give me a grid of people, showing when they are on holiday, and highlighting which holidays clash.
I think its to do with hlookup etc, but I'm stuck after that!