Question: How to Make Fillable Form for Multiple Inputs Into the Same Form?

%3CLINGO-SUB%20id%3D%22lingo-sub-3214587%22%20slang%3D%22en-US%22%3EQuestion%3A%20How%20to%20Make%20Fillable%20Form%20for%20Multiple%20Inputs%20Into%20the%20Same%20Form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3214587%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20make%20an%20excel%20form%20that%20multiple%20people%20could%20fill%20out%2C%20like%20a%20registration%20form.%20And%20I%20want%20to%20be%20able%20to%20save%20each%20person's%20filled%20out%20form%20for%20later%20viewing%20(kind%20of%20like%20Google%20Forms%20can%20do).%20But%2C%20I%20don't%20want%20to%20have%20to%20make%20a%20new%20worksheet%20for%20every%20time%20someone%20fills%20out%20the%20form%2C%20because%20this%20would%20mean%20over%2060%20worksheets%20in%20one%20file.%20And%20if%20I%20have%20to%20make%20a%20later%20edit%20to%20the%20form%20template%2C%20I%20don't%20want%20to%20have%20to%20do%20it%2060%2B%20times.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIs%20there%20a%20way%20I%20can%20do%20something%20like%20this%20in%20Excel%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20reason%20I%20haven't%20used%20Google%20Forms%20is%20because%20I%20like%20the%20customizability%20of%20excel%2C%20plus%20I%20don't%20want%20to%20store%20any%20sensitive%20information%20on%20the%20web.%20Thanks%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3214587%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3218630%22%20slang%3D%22en-US%22%3ERe%3A%20Question%3A%20How%20to%20Make%20Fillable%20Form%20for%20Multiple%20Inputs%20Into%20the%20Same%20Form%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3218630%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318093%22%20target%3D%22_blank%22%3E%40Daniel_Beatty%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsurveys-in-excel-hosted-on-the-web-5fafd054-19f8-474c-97ec-b606fcda0ff9%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESurveys%20in%20Excel%2C%20hosted%20on%20the%20OneDrive%3C%2FA%3E%3C%2FP%3E%3CP%3ESurveys%20let%20other%20people%20fill%20out%20your%20list%E2%80%94like%20a%20sign-up%20sheet%20or%20questionnaire%E2%80%94where%20you%20can%20see%20it%20all%20in%20one%20place%20online.%20Here%E2%80%99s%20how%20to%20create%20your%20survey%20in%20OneDrive%20and%20OneDrive%20for%20work%20or%20school.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20information%2Flink.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

 

I am trying to make an excel form that multiple people could fill out, like a registration form. And I want to be able to save each person's filled out form for later viewing (kind of like Google Forms can do). But, I don't want to have to make a new worksheet for every time someone fills out the form, because this would mean over 60 worksheets in one file. And if I have to make a later edit to the form template, I don't want to have to do it 60+ times.

 

Is there a way I can do something like this in Excel?

 

The reason I haven't used Google Forms is because I like the customizability of excel, plus I don't want to store any sensitive information on the web. Thanks for your help!

1 Reply

@Daniel_Beatty 

Surveys in Excel, hosted on the OneDrive

Surveys let other people fill out your list—like a sign-up sheet or questionnaire—where you can see it all in one place online. Here’s how to create your survey in OneDrive and OneDrive for work or school.

 

Hope I was able to help you with this information/link.

 

NikolinoDE

I know I don't know anything (Socrates)