Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Quickly compile Form Field data from multiple forms in Excel?
I am trying to build a Word 2003 form that will allow me to quickly compile
data from the fields in Excel. So if I have 200 forms, I will be able to open excel, update it with the completed form fields and have each Field occupy a different row. e.g: Name(field 1) Dept (field 2) Salary (field 3) bob Sales 40k mary Finance 30k joe Marketing 80k Any help is greatly appreciated. |
#2
|
|||
|
|||
See the last of the following series of articles
Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "jgundel" wrote in message ... I am trying to build a Word 2003 form that will allow me to quickly compile data from the fields in Excel. So if I have 200 forms, I will be able to open excel, update it with the completed form fields and have each Field occupy a different row. e.g: Name(field 1) Dept (field 2) Salary (field 3) bob Sales 40k mary Finance 30k joe Marketing 80k Any help is greatly appreciated. |
#3
|
|||
|
|||
thank you!
"jgundel" wrote: I am trying to build a Word 2003 form that will allow me to quickly compile data from the fields in Excel. So if I have 200 forms, I will be able to open excel, update it with the completed form fields and have each Field occupy a different row. e.g: Name(field 1) Dept (field 2) Salary (field 3) bob Sales 40k mary Finance 30k joe Marketing 80k Any help is greatly appreciated. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you convert regular text in a table into form field data easil | Microsoft Word Help | |||
Enter data in 1 text form field & have multiple locations fill | Microsoft Word Help | |||
Retaining formatting on a single line after entering data in field | Page Layout | |||
Word Field Codes in Excel data file | Mailmerge | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help |