Home

Using Excel to Generate a Fillable Form

%3CLINGO-SUB%20id%3D%22lingo-sub-476972%22%20slang%3D%22en-US%22%3EUsing%20Excel%20to%20Generate%20a%20Fillable%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-476972%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20have%20a%20specific%20fillable%20form%20(from%20a%20bank%20of%20multiple%20forms)%20generate%20based%20on%20a%20certain%20input%20field%20on%20an%20Excel%20spreadsheet%3F%20For%20example%2C%20if%20I%20was%20an%20auto%20mechanic%20and%20wanted%20to%20generate%20a%20specific%2C%20tailored%20form%20for%20those%20customers%20who%20have%20SUVs%2C%20coupes%2C%20or%20pick-up%20trucks%20based%20on%20a%20specific%20input%20field%20on%20a%20spreadsheet%2C%20is%20Excel%20capable%20of%20that%3F%20I%20do%20not%20have%20much%20experience%20with%20Excel.%20%26nbsp%3BAlthough%20I%20couldn't%20find%20any%20answers%20online%2C%20I'm%20crossing%20my%20fingers%20that%20someone%20in%20this%20forum%20will%20know%20whether%20Excel%20is%20capable%20of%20this.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-476972%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%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-477018%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Excel%20to%20Generate%20a%20Fillable%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-477018%22%20slang%3D%22en-US%22%3EYou%20can%20store%20each%20individual%20form%20in%20separate%20sheets.%20Based%20on%20the%20choice%20made%20in%20an%20input%20cell%2C%20you%20can%20create%20a%20hyperlink%20formula%20to%20jump%20to%20the%20sheet%20containing%20the%20form%20to%20which%20the%20chosen%20input%20pertains.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-477648%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Excel%20to%20Generate%20a%20Fillable%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-477648%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20your%20help%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
southernbelle803
New Contributor

Is it possible to have a specific fillable form (from a bank of multiple forms) generate based on a certain input field on an Excel spreadsheet? For example, if I was an auto mechanic and wanted to generate a specific, tailored form for those customers who have SUVs, coupes, or pick-up trucks based on a specific input field on a spreadsheet, is Excel capable of that? I do not have much experience with Excel.  Although I couldn't find any answers online, I'm crossing my fingers that someone in this forum will know whether Excel is capable of this. 

2 Replies
You can store each individual form in separate sheets. Based on the choice made in an input cell, you can create a hyperlink formula to jump to the sheet containing the form to which the chosen input pertains.

Thank you for your help, @Twifoo 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
17 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies