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)