Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help with merge

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need help with a merge. I have a spreadsheet with personal info (about 100 members). I need to print out a form for each member with their individual info (like ID #, birth date, name). I have the form in Excel as well. Is there a way I could set this up like a Mail Merge so that I can just do one form and it will fill in the individual information automatically without me having to cut and paste each one or type manually?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You might want to use vlookup for this.

    Name the range of data relating to the 100 members, for example, "membersdata", with the ID in the first column of this range. If the ID is not 1,2,3,4...etc then you might want to assign a new ID of this nature for the first column, just for this purpose.

    Then on the form that requires the info, enter the ID by hand somewhere on or off the form, and in the other fields put, for example:

    =VLOOKUP(A1,membersdata,2,false)

    which will get the id from cell A1 of the current sheet, look it up in the first column of the named range, and return the value from column 2 of the named range, etc etc...

    Then you only need change the ID cell and the rest of the info will update automatically, and print and then change to the next ID, etc...

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    To add also could bve merge by that i nean trans into Word... yuuuuck! but the fields need to be set correctly and also toggle button to scan enloyees by alpha name or number data pulled in from Excel data source..

    will be fine..

    Your question was hinting at Merger.. yes i beleive you can... suggest play and use wizards...


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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