Hi Tony
I must say I'm very impressed. I've had a play around and a couple of thoughts come to mind now I see how you have done this.

The report cell on each patient page does need to expand vertically with its content, at the moment content is hidden after 5-6 lines of type, you'd be suprised how much un necessary junk nurses write, but I have to ensure it is all visable.

how do you link text to another page, I'd like to duplicate the names on sheet one again in an additional column on the last page (pt 1 name on both sheets), in an ideal world this could do the same in the relevant cell in each patients sheet, but I fear I may be asking too much, hence how do you do it?

lastly do you think it possible to add a back command button at the end of each patient sheet, to take them back to the summary.

This is begining to look how I visualised it in my mind but my skills in excel are somewhat limited and word didn't really match up to the task. I was begining to think I may need to use access but that would absolutely panic most of my team. This is going to need several teaching sessions to ensure they don't mess it up.

I've attached the copy I had a look at, I've unlocked the to do cells on the individual as protection prevented data entry and I found protecting the summary sheet disabled the links to the various worksheets

many thanks again
Steve

Attached Files

Ward Shift Handover List-1C.zip (36.3 KB, 19 views)