Hello,



I'm am trying to figure out a way to use Excel to automatically fill out a form with information stored on another page, in a way that it will create multiple forms in one easy process.

To go into more detail, I am responsible for issuing weapons out of an arms room and we have certain paperwork that has to be filled out for each weapon issued. The paperwork tells who the weapon goes to and the serial number of each weapon and the attachments that are on on it.

I would like to create a master list of who the weapon is assigned to and what attachments are on it, and use that list to automatically fill out the DA2062 form that is required for each issue.

Any guidance would be appreciated.

Hi
you could Word's "mail merge" functionality for for this using XL as data source.
Have a look a the Word forum, lots of information on the subject.

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Deleted again.