Hi,

So I have an issue which I am desperate to solve to improve the registering of customer visits from one workbook to another. I have a customer tracker which is geared up to prompt my staff into following the same procedure with all customers which prompts them once something has completed (we have lots of processes before we can accept a client which we dont have a designated administrator for)

Anyway, once the client is booked and a date is confirmed, I need it to automatically insert the name of the client and the booking date onto a separate calendar spreadsheet on the correct day. I have 5 rows available for each day of the calendar year so it would also have to look for the next available slot. its highly unlikely all 5 rows would be filled in a day.

Is this possible? is there some magic formula I can use to complete this without getting into macros?

on the customer tracker cloumn A represents the customers name and column R represents the date booked - I need the customer name automatically inserted on the relevant day on the calendar and to look for the first available slot (row) on that date.

I would send both workbooks but the have a lot of sensitive information on. Please see snip of the calendar for reference.Diary.PNG