I have a form that is presently in Word that is more appropriate to be in Excel as it includes calculations.
In the past, I would consider using Excel Userforms that would compile the ten questions plus header information for the form on a separate sheet.
Can I instead have a simple Excel spreadsheet where each completed form would located in the file named Current Month. If there were twenty forms completed, I would then use Power Query to consolidate all the forms into a simple table.
- Is this as easy as it sounds?
Thanks for your insight.
Greg
Hi Greg,
I'd use Excel Survey to collect your data. You can add columns to the table created by Excel survey and add your formulas in there. Otherwise I'd use Excel Forms to collect the data and put the entries straight into one table, rather than separate tables which then need to be summarised.
Hope that helps.
Mynda
