Help with merge

cla

New Member
Joined
Apr 2, 2002
Messages
5
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?
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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...
 
Upvote 0
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...
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top