Hi All, I wonder if anyone can help me with this query please.
I have a spreadsheet that we use as a diary for room bookings. I call this my Master Diary. It has a column for each room, and rows for each timeslot. The information is set to automatically pull from each one of our services individual diaries, eg. SLT Diary, CAMHS Diary, etc. I set this up using simple ='[Diary - SLT.xlsx]Thur 20-02-25'!I67 formulas. My Master Diary is often updated during to course of the day as appointments are added or removed from the services diaries. This is all working fine, I'm just explaining so you know how it works.
What I now want to do is create a separate spreadsheet that can pull the appointments from the Master Diary and display them as a simple list ordered by start time. I have created a dummy version of what I would like it to look like. Hopefully by looking at the image you will see what I am trying to achieve. The purpose of this is the Master Diary sheet for each day is quite large and clunky for our receptionists to work with. I am hoping I can create a more user friendly sheet that the receptionists can keep open and see a 'live list' of who is due to attend, and they can then indicate whether they arrive or not.
For info, where you can see a slot marked 'As above', I want the appointment list to ignore these. The reason we use 'As above' is to indicate the appointment is expected to continue beyond the original 30 minute time slot.
I'm really hoping someone knows a way of doing this! Thanks in advance.
I have a spreadsheet that we use as a diary for room bookings. I call this my Master Diary. It has a column for each room, and rows for each timeslot. The information is set to automatically pull from each one of our services individual diaries, eg. SLT Diary, CAMHS Diary, etc. I set this up using simple ='[Diary - SLT.xlsx]Thur 20-02-25'!I67 formulas. My Master Diary is often updated during to course of the day as appointments are added or removed from the services diaries. This is all working fine, I'm just explaining so you know how it works.
What I now want to do is create a separate spreadsheet that can pull the appointments from the Master Diary and display them as a simple list ordered by start time. I have created a dummy version of what I would like it to look like. Hopefully by looking at the image you will see what I am trying to achieve. The purpose of this is the Master Diary sheet for each day is quite large and clunky for our receptionists to work with. I am hoping I can create a more user friendly sheet that the receptionists can keep open and see a 'live list' of who is due to attend, and they can then indicate whether they arrive or not.
For info, where you can see a slot marked 'As above', I want the appointment list to ignore these. The reason we use 'As above' is to indicate the appointment is expected to continue beyond the original 30 minute time slot.
I'm really hoping someone knows a way of doing this! Thanks in advance.
