#1
|
|||
|
|||
Auto Fill Forms
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. |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Deleted again.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fill MS-Word docs/forms with name address data from external source | yajnaval | Word | 2 | 02-14-2015 10:48 PM |
Fill In PDF Forms with Word | dlowrey | Word | 2 | 09-24-2012 09:55 PM |
Automated forms fill out and save as doc | pierla | Word | 1 | 06-28-2012 10:52 AM |
Fill-in forms using Word Tables | BigJspice | Word Tables | 3 | 06-25-2012 07:22 AM |
Fill-in Forms | turk07 | Word | 1 | 06-05-2010 06:43 AM |