+ Reply to Thread
Results 1 to 3 of 3

Auto Filling text?

  1. #1
    Registered User
    Join Date
    09-25-2009
    Location
    San Diego
    MS-Off Ver
    Excel 2003
    Posts
    4

    Auto Filling text?

    Hello all,

    I had a quick and simple question that I couldnt seem to fnid anywhere online.

    Alright so I have a word document that is several pages and requires me to input a name, rank, and date. I'm trying to find a way to just enter a blank field on the first page that when filled in will show the exact same text in the same spots on the other pages so for example If I enter a name the same name will be displayed on the second, third , fourth.... etc etc.

    Is it a Field? or a Macro? Any help is appreciated.

    Thanks in advance,
    Aaron

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Auto Filling text?

    Hi,

    my gut feeling approach is this:

    use one of the Heading styles for your data entry fields on the first page (format the style to suit your purpose). I just assume that you will not use the headings for a table of contents.

    Now enter your name, rank, date, etc, and assing the heading style to these paragraphs.

    Next, specify that the document should have page Headers, different first page (via File - Page setup). I don't care much about how you style your first page header, or if you leave it blank, but edit your second page header and create a cross-reference to the items on the first page, using

    Insert - Reference - cross-reference
    reference type = Heading
    Insert reference to = Heading text

    for each data item you want repeated on the top of each page.

    Style this page header to suit. Items can even be on the same line, or on separate lines; define how much space the header takes up, etc.

    Now this second page, and every consecutive page will have this header with name, rank, date etc. in it, just as you specified.

    If you edit/change the information on the first page, double-click the header to edit, then select all (CTRL-A) and hit F9 to update the reference fields.

    Does that make sense??? I've tried it out in Word 2007, but it should work in 2003 just as well.

    cheers

    PS: added sample Word 2003 file
    Attached Files Attached Files
    Last edited by teylyn; 09-27-2009 at 06:22 PM. Reason: added sample Word 2003 file

  3. #3
    Registered User
    Join Date
    09-25-2009
    Location
    San Diego
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Auto Filling text?

    Thanks, that makes sense! I'll try it out!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1