Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Compile/Analyze Word Form Field data from multiple forms?
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 I am trying to avoid doing this manually. Any help is greatly appreciated. |
#2
|
|||
|
|||
You may have wanted to crosspost this into both an MSWord newsgroup along with
this one. I included .docmanagement in my reply. (I don't spend much time in the MSWord newsgroups. If there's a better one, maybe someone will reply.) 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 I am trying to avoid doing this manually. Any help is greatly appreciated. -- Dave Peterson |
#3
|
|||
|
|||
This was multiposted to a Word NG and has received an answer there.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Dave Peterson" wrote in message ... You may have wanted to crosspost this into both an MSWord newsgroup along with this one. I included .docmanagement in my reply. (I don't spend much time in the MSWord newsgroups. If there's a better one, maybe someone will reply.) 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 I am trying to avoid doing this manually. Any help is greatly appreciated. -- Dave Peterson |
#4
|
|||
|
|||
Thank you, Suzanne.
This was the thread: http://groups.google.co.uk/group/mic...b 0c5628e4878 Or... http://tinyurl.com/8yunu "Suzanne S. Barnhill" wrote: This was multiposted to a Word NG and has received an answer there. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Dave Peterson" wrote in message ... You may have wanted to crosspost this into both an MSWord newsgroup along with this one. I included .docmanagement in my reply. (I don't spend much time in the MSWord newsgroups. If there's a better one, maybe someone will reply.) 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 I am trying to avoid doing this manually. Any help is greatly appreciated. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Data Field Query | Excel Worksheet Functions | |||
Data validation in data form? | Excel Discussion (Misc queries) | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
Getting specific data from a word document into an excel sheet | Excel Worksheet Functions | |||
How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions |