Hi, I couldn't find any request instructions. So sorry if this one's inaccurate.

I have a "sheet 1" with a list of peoples travels. It has a lot of information but the important columns are Name, Trip start date and Trip end date.

Each row equals each trip so every person have multiple entries.

In sheet 2 I have a timeline with every person in column A. The rest of the columns are dates from jan 1 to dec 31.

I'd like to make a loop that takes each row from sheet 1, adds a background color in the cells on the row with the corresponding employee name in sheet 2 - from the column with the corresponding start date, all the way to end date.

The columns of the timeline will have headers like 2014-01-01 | 2014-01-02. So COLOR cell WHERE rowheader=samename AND columnheader=startdate. Do this until rowheader=samename AND columnheader=enddate. Or something similar? I haven't been working with VB for many years though.

So, one person will have multiple trips in the timeline. Kinda lika a vacation list or calendar.

Would be greatful for any tips at all!