Excel - Generate Spreadsheet from Form

[DoovidToonet]

I have an idea for an Excel spreadsheet generator, and am wondering if my idea would be feasible using the Microsoft suite of products. This would be used to automatically generate spreadsheets for my job. The idea I have is making a form that would ask the following:

 

1. Vendor - would affect certain tax rates

2. State - would affect which state's taxes are brought in

3. Product Type - affects which taxes are brought in

4. Prices and Quantity - completes the spreadsheet

 

Would I be able to go forward with this within Excel/Microsoft's products at all without needing to use VBS scripts, or am I talking outside the ability of these products alone? In all honestly, the system we currently use works well (multiple saved spreadsheets for each vendor/state), however this is partially me being curious to see if this could even be done.

[Avocado Diaboli]

I'm not sure I understand you correctly. What do you mean by "spreadsheet"? Are you intending to make a database of individual entries or is this something akin to an invoice that should be generated in Excel based on a few choices made along the way? Without knowing which, it's hard to gauge what you actually want to achieve or how to go about achieving it, so please provide a bit more information, not just about what you intend to do, but more importantly what the result should be. Basically, be aware of the XY problem.

[LogicalDrm]

There's Microsoft Forms, but I don't think it will achieve what you actually want. I use more advanced survey creator in my job and it will require quite a lot manual work to move data from it to master Excel sheet to be then projected to PowerBi.

 

What you most likely are after is database-based business records manager and to that, there are tons of premade solutions.