Column = Row Then Gnatt Chart Scheduling

I want to create vba that looks for a date in a row and return start where it matches the row and column values and outputs a value in the cells where they meet up.

(very confusing, kind of like a gantt chart). The purpose is for a user to input activity with start and finish dates and the "gantt chart" to fill out.

Activity Start Finish 3/13 3/14 3/15 3/16 3/17

Floors 3/14 3/17 (blank) START X X FINISH

Mirror 3/15 3/16 (blank) (blank) START FINISH (blank)

For example the input values:

cell a1: activity, cell b1: start, c1: finish, d1: 3/13, e1: 3/14, f1: 3/15, g1: 3/16, h1: 3/17

cell a2: floors, b2: 3/14, c2: 3/17

cell a3: mirror, b3: 3/15, c3: 3/16

Then I want the output to put start and finish in the rows where they match up.

cell a1: activity, cell b1: start, c1: finish, d1: 3/13, e1: 3/14, f1: 3/15, g1: 3/16, h1: 3/17

cell a2: floors, b2: 3/14, c2: 3/17, e2: START, h2: FINISH

cell a3: mirror, b3: 3/15, c3: 3/16, f3: START, g3: FINISH

Then I also want the areas in between (for floors the 3/15 and 3/16 dates) to be marked with an X.

cell a1: activity, cell b1: start, c1: finish, d1: 3/13, e1: 3/14, f1: 3/15, g1: 3/16, h1: 3/17

cell a2: floors, b2: 3/14, c2: 3/17, e2: START, f2: X, g2: X, h2: FINISH

cell a3: mirror, b3: 3/15, c3: 3/16, f3: START, g3: FINISH