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.