Forum Discussion
southernbelle803
Apr 20, 2019Copper Contributor
Using Excel to Generate a Fillable Form
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
Sort By
- TwifooSilver ContributorYou 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.
- southernbelle803Copper Contributor
Thank you for your help, Twifoo