Is it possible to enter text in one place in a word 2007 document and have it repeat elsewhere at the end of the same document?

I have a multi table document that relates to multiple individuals. One cell of each table has a 'to do' section where I would like to replicate the inputted text at the end of the document, a sort of work sheet that I can print off (printing current view).

I've had a look about and I can find references to bookmarks, linking fields and cross referencing etc but most don't seem very clear in what to do, especially in word 2007/10.



I'm using word 2007 and saving in 2003 .doc format to allow compatability with the work pc
If any one knows the clear and simple way to achieving this, it will be greatly appreciated

The different ways to repeat data in Word are described here: http://gregmaxey.com/Repeating_Data.htm.

__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional

I've had a read of this and I'm not sure if this is what I need.

I'm not looking at, for examnple, automatic address or name entry, but free text

The principle is the same, no matter if you repeat "free" text or a name and an address. Try the online form option for example.

__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional

Hi
What Stefan is saying is absolutely right. Perhaps if you can post a sample we may be able to provide you with a solution.
Tony(OTPM)

Ok Guys
This is a draft version of the document I am working on to improve patient handovers within the ward I work on. It's only a partial document to meet the limits to attachments but you can see the principal I'm trying to achieve. I've saved it in word 2003 as this is what we run at work.

At the present it doesn't have protection as I found protecting the form disabled the links (patient 1,2 etc command and Back buttons) unless you guys know a way to do this.

I want to add to the bottom of the document either a single cell with headings (patient 1, patient 2 etc) or a 22 row table, which ever works best, again with rows labled patient 1, 2 etc.

What I am trying to do is link the patient 'to do' section to the appropriate headed section in the cell/table row so that what I type in 'to do' appears in the equivelant section at the bottom.

This will give me a printable section (print pages X & Y) to create a job list for the oncoming shift and cut out the need to make written notes (and the errors this can create) and the need to print the whole document.

Please do experiment and let me know your thoughts

Attached Files

handover test a.doc (400.0 KB, 31 views)

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, 20 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, 12 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, 19 views)

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, 17 views)

I've been thinking about the report section, Maybe about 10 rows of text. I did notice the cell 'Pad size' does auto resize. Maybe widen the total cell width to full page width?
Steve