How do I use an Excel form to populate and Excel spreadsheet
I want users to enter date, name, question # and score into an Excel form, and have the information populate the appropriate column/row in an Excel spreadsheet (separate tab which will be used to pull reports). The historical information must be saved in the spreadsheet, even when the form is used to enter the next set of data. How can I best accomplish this?
|