Help with collection scheduling information to a seperate sheet

[Guest]

10 doctors in an office. Each one has a different sheet in a workbook.
The left 2 columns looks like this…
Header row and then the schedule for the day followed by another header row
and the next days schedule. L1 or L2 stands for the room they are in for the
day.

L1 Thu Jul 15
5:00 Niko Haritos
5:30
6:00
6:30
7:00
7:30 Johnny Sanford
8:00 Ryan Coleman
L2 Fri Jul 16
5:00 Macy Dechamplain
5:30
6:00
6:30

I want to create another sheet in the workbook that represents (with shading
or maybe the doctor’s name) when each of the rooms are occupied and by which
doctor. I need this to update dynamically of course. I can’t figure this
out for the life of me. Help!

 

[Patrik Karlstrom]

Well, it should work if you linked the info from the first sheet to the
next. Copy each individual cell and Paste Special in the new sheet and
select Paste Link.

Best,
Patrik Karlstrom

 

[Frank Kabel]

Hi
not so easily done It would be better if you had one sheet with all
the schedule information and the name of the doctor as a separate
column. With this layout you could use Excel's build features such as
Autofilter/Advanced Filter, Sorting, etc.