Originally Posted by Stevejd58

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.

Steve: I have expanded the report and To Do rows to fit on an A4 page. Hopefully this will be sufficient space for each of these fields. The problem we have is that because we have to use merged cells you cannot use AutoFit. This is why I was looking for some VBA code to do this for us and am still waiitng for any feedback from the Forum. If I get some I will send you a new version.



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?

Steve: To link text to another cell (on any sheet) all you do is right click on the cell(s) you want to copy. Then click on the cell(s) where you want to repeat the data and right-click and select Paste-Link. This will copy the data and any changes made to the source data will automatically reflect in the target cells.

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.

Steve: There is already this functionality which I mentioned in my last update. To the left of the first viewed sheet tab there are four arrow type icons io the bottom left hand corner of the screen. All you need to do is right-click on any of those arrows and you will be presented with a list of the sheets contained in this workbook. Simply click on the sheet name you want to move back to. If there are more sheets than can be viewed in the first dialogue box then click on "More sheets" at the bottom of the list and you can then scroll through the list and select the sheet you wish to move to. By default the Summary Sheet will always be the first sheet you see when you first right-click on one of these arrows.

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.

Steve: There should be little training involved as all the blue cells are locked so users cannot change them.

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