Hi all.
I'm creating a call log for those staff who are on flexible furlough so we can monitor which days everyone is working and also have a centralised record of the contact.
So the call log is something like this (tab is named 'Call log'):
The tricky bit, however is populating the calendar - here's an extract of the calendar (tab is named 'Calendar':
So as you can see, I intend for us to input a date commencing and a date ending to give a range of dates that the employee is in the office. For that range I want each date that a person is in the office to have the word "In" in the relevant cell on the calendar. Other cells can remain blank. I've omitted weekends from the calendar.
That's difficult enough but please bear in mind that we could be bringing people back several times during the month. I considered using a VLOOKUP but that would only pick up the first result for each staff member. If we call them in several times during the month I need every day to be included.
I hope that makes sense and would be really grateful for any assistance.
I'm creating a call log for those staff who are on flexible furlough so we can monitor which days everyone is working and also have a centralised record of the contact.
So the call log is something like this (tab is named 'Call log'):
The tricky bit, however is populating the calendar - here's an extract of the calendar (tab is named 'Calendar':
So as you can see, I intend for us to input a date commencing and a date ending to give a range of dates that the employee is in the office. For that range I want each date that a person is in the office to have the word "In" in the relevant cell on the calendar. Other cells can remain blank. I've omitted weekends from the calendar.
That's difficult enough but please bear in mind that we could be bringing people back several times during the month. I considered using a VLOOKUP but that would only pick up the first result for each staff member. If we call them in several times during the month I need every day to be included.
I hope that makes sense and would be really grateful for any assistance.