Data into an Excel Form

[SamKCMO]

I created a form in Excel 2 fields are intended to capture Employee ID# and
the other Employee Name (no need for separate fields for First & Last). I
have a list of names & ID# also in Excel which I need to create 200+
individualized forms. I would like to generate the forms without having to
type the Names & ID# into each field. Is there some sort of merge feature I
can use that will save me time? Any solutions will be greatly appreciated.

 

[Harald Staff]

Depending on what this is for, but if it is for print then I'd make the form
in Word and merge using the Excel list as data source. It's not too
intuitive, but well described in Word Help.

HTH. Best wishes Harald

 

[SamKCMO]

Thanks for the quick response.

Recreating the form in Word is proving to be a difficult task b/c of all the
cell configurations and the margins don't tranfer well, the form is easier
used in Excel. Any chance of just working b/w excel documents?

 

[Dave Peterson]

Maybe you could use these from Debra Dalgleish's site:

http://contextures.com/xlForm02.html
and
http://contextures.com/xlForm03.html

 

[Harald Staff]

Excel doesn't do "mailmerge" like Word does. But it's not clear to me what
"I need to create 200+ individualized forms" really is, so I have no other
answer ready to run. This said, one can do absolutely everything with VBA
macros, so there's always a chance.

HTH. Best wishes Harald