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.
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.