Hi Steve
Perhaps a more easier option would be to use Excel. I have attached a very basic Mock Up of your document to show what can be done.
Page 1 contains the patient records and page 2 contains links to the To-Do box on the first page. Anything entered in the to-do box on the first page is automatically entered on the second page against the relevant patient.
Let me know if this is a potential solution for you and I would be happy to assist you further.
Good luck.
Tony(OTPM)

Attached Files

Ward Shift Handover List.xls (30.0 KB, 22 views)

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)

Hi Steve
I will do a little more work on your updated Excel doc and we can speak again to agree where you need to be. I am happy to work with you to get to where you want to be.
Tony(OTPM)

Hi Steve
Here is where I am so far.
All BLUE cells are locked so users cannot change them.
The To-Do handover sheet is automatically updated by each individual patient record.
The To-Do handover sheet is totally locked so no one can change it.
I am just waiting for some help on the forum with a piece of vba code that automatically changes the cell height to adjust to the amount of text entered. This is because when you merge cells the auto row height does not work.
I will send the updated workbook as soon as I have that code.
Kind regards.
Tony(OTPM)

Hi Tony
This sounds even better, now once you get into visual basic, I'm lost. Maybe something I should learn, know any good resources I can learn from?

This is going onto a share point document library at some point and will be updated x3 daily, the previous being in an archive so I will have an evidence trail should something happen. Already got the access permissions sorted.

I very much appreciate the time that you and your friends are giving to this.

Hi Steve
I am struggling with the macro to automatically resize rows when text is entered. Do you have any idea how much text you are likely to put in each cell?
Tony(OTPM)

Hi Steve
For now I have dispensed with trying to resize the rows by macro and sized them to allow what should be sufficient text in each box.
All blue cells are locked to stop users modifying them.
The Handover Sheet at the end of the Workbook will update and resize all rows as soon as you click on any cell on the table. You can then print this sheet as normal. Don't worry about the blue selection, when you print it will print correctly.
The workbook can be set to view Full Screen on each page so you dont see all the toollbars, you can cancel this by selecting the close full screen button top left hand corner of the screen.
Another way of moving to another worksheet if you cannot see all the table is to right-click on one of the arrows at the bottom left hand corner of your worksheet screen. This will bring up a dialogue box where you can select which worksheet you wish to view.
The workbook needs a thorough test before use but let me know what you think and if you need anything else then get back to me.
Good luck.
Tony(OTPM)

Attached Files

Ward Shift Handover List-1b.zip (39.1 KB, 21 views)