Hi All,

I have a time schedule that auto populates when you change the date from a list of jobs on a separate tab. I currently have it setup to display the word "allocated" but ideally I want 3/4 of the fields from that job to populate the cell/s. At the same time, ideally I would like it to change colour depending on the status (as in the jobs tab) but also for those cells to auto merge and then unmerge when the date is changed.

I know this is a lot to ask but if some one can help with some or all of it I would be greatly thankful. I'm officially stuck!!!!!!!!

Drivers Schedule.xlsx

Many Thanks

Wayne