This looks good so far. with the word doc I was working on the principal of telling staff, if its blue 'don't touch it', only alter the white areas. this shouldn't be too much of a problem in excel.

The first question I have is, Just how did you set it to duplicate in sheet 2? I assume what you set up is tied to the cell and not the sheet.

This is going to be displayed on a smart board and networked to a 50" plasma TV (used as a pc monitor) in another room. Is it possible to display this as a form/document, much as you see in print preview?

I need to keep the visual aspect as simple as possible as I have staff who could wipe the internet if it wasn't tightly controlled. Additional cells on view will confuse some of them and lead to document corruption and a headache for me.

I've had a bit of a play with the format, now how to format the front sheet similar in some way to the word document and additional tables below patient 1

Attached Files

Ward Shift Handover List-1b.xls (26.0 KB, 14 views)