Checking Bookings - VBA Help Needed

[Nat1978]

Hi Guys,

Hoping someone could help me. I'm using Excel for Mac 15.39.

I have a spreadsheet with two sheets, shown below:

1. Calendar

	23/10/17	24/10/17	25/10/17	26/10/17	27/10/17	30/10/17	31/10/17	01/11/17	02/11/17	03/11/17	more dates --->
John Doe
Jane Doe

<tbody>
</tbody>

This sheet has 60+ people listed with week day dates along the top.

2. Tasks

Task	Start Date	End Date	Content	Status	Assigned
P1	24/10/17	25/11/17	TT	Booked	John
P2	23/10/17	30/10/17	AD	Booked	Jane
P3	26/10/17	02/11/17	TD

<tbody>
</tbody>

This sheet has 100+ Tasks listed.

What I am trying to do:

I am trying to get the data in the Sheet called Tasks to fill cells in Sheet called Calendar like this:

	23/10/17	24/10/17	25/10/17	26/10/17	27/10/17	30/10/17	31/10/17	01/11/17	02/11/17	more dates ---->
John Doe		P1 TT	P1 TT	P3 TD	P3 TD	P3 TD	P3 TD	P3 TD	P3 TD
Jane Doe	P2 AD	P2 AD	P2 AD	P2 AD	P2 AD	P2 AD

<tbody>
</tbody>

Currently I am updating as needed manually on a daily basis.

Couple of things to note:

Sometimes Tasks for a single person overlap - if this is the case currently I create a new row underneath and show overlap in Tasks this way - ideally I'd want to try and do the same so for the example above....if task P3 started on the 25/10/17 it would look like this:

Also if another task was lined up to Joe e.g P4 TT 31/10/17 - 02/11/17 it would fill the first row if it was empty as shown, rather than create another row...if both rows were full however it would create another row....sorry if this sounds confusing but hopefully below shows what I mean:

	23/10/17	24/10/17	25/10/17	26/10/17	27/10/17	30/10/17	31/10/17	01/11/17	02/11/17	more dates ---->
Joe Doe		P1 TT	P1 TT				P4 TT	P4 TT	P4 TT
(merged with above cell)			P3 TD	P3 TD	P3 TD	P3 TD	P3 TD	P3 TD	P3 TD
Jane Doe	P2 AD	P2 AD	P2 AD	P2 AD	P2 AD	P2 AD

<tbody>
</tbody>

I'm hoping someone could help me? I've done a bit of VBA in the past but I was not sure how start doing this!?!