#1
|
|||
|
|||
Using a Form in Word to create an Excel spreadsheet
Evening, I have created a form in Word. I want to create a spreadsheet from this form. A single form is easy - or seems to be - but what if I have multiple forms? It should be easy but I haven't worked with this sort of thing for a long time and I'm a bit lost. I would be very grateful if someone could give me some pointers. |
#2
|
|||
|
|||
Form in Word?
UserForm? Create a Simple Userform by Graham Mayor, MVP Document Form? Create a Form Using Word Content Controls by Greg Maxey Last edited by Charles Kenyon; 06-13-2022 at 06:12 PM. |
#3
|
||||
|
||||
Rosie
Charles' links don't appear to be directly relevant to your request if you have already created the form. To me, your question appears to be asking how to extract/collate the responses from multiple forms into a single Excel worksheet. Unfortunately, this is not a simple request and it will likely require considerable effort to get this setup. It also varies with how the Word form was created and whether it uses Content Controls or Form Fields for the data fields. If that is the case, something like this may be more relevant to you. https://www.youtube.com/watch?v=1x-Vk4Qmpz0 How to transfer data from Word forms to an Excel worksheet | TechRepublic
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#4
|
||||
|
||||
Why are you creating a form in Word if you want the data in Excel?
As it stands, your question is too vague for anyone to provide a meaningful answer.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
word form; excel; |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to create barcode in Excel spreadsheet using Microsoft Office 365 ProPlus | lisa.smith@sdcounty.ca.go | Excel | 2 | 11-29-2019 07:34 AM |
Would like to mail merge excel spreadsheet with word doc and create new page when a catagory changes | esherwood | Mail Merge | 1 | 07-21-2014 09:55 PM |
Create template that auto-fills from excel spreadsheet | m.buskirk5 | Publisher | 0 | 07-02-2012 03:09 PM |
Word Fill-in form with Excel spreadsheet | karik | Word | 0 | 01-11-2010 08:45 AM |
How do I use an Excel form to populate and Excel spreadsheet | apostht | Excel | 0 | 05-21-2006 11:17 AM |