Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2022, 11:58 AM
Rosie.Orton Rosie.Orton is offline Using a Form in Word to create an Excel spreadsheet Windows 11 Using a Form in Word to create an Excel spreadsheet Office 2019
Novice
Using a Form in Word to create an Excel spreadsheet
 
Join Date: Jun 2022
Posts: 1
Rosie.Orton is on a distinguished road
Unhappy 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.
Reply With Quote
  #2  
Old 06-13-2022, 12:20 PM
Charles Kenyon Charles Kenyon is offline Using a Form in Word to create an Excel spreadsheet Windows 10 Using a Form in Word to create an Excel spreadsheet Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

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.
Reply With Quote
  #3  
Old 06-13-2022, 06:06 PM
Guessed's Avatar
Guessed Guessed is offline Using a Form in Word to create an Excel spreadsheet Windows 10 Using a Form in Word to create an Excel spreadsheet Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #4  
Old 06-13-2022, 06:07 PM
macropod's Avatar
macropod macropod is offline Using a Form in Word to create an Excel spreadsheet Windows 10 Using a Form in Word to create an Excel spreadsheet Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

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
Using a Form in Word to create an Excel spreadsheet 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft