Forum Discussion
fcosta1029
May 16, 2024Copper Contributor
Gathering Data from Excel Fillable Form into One Master Spreadsheet
Hello,
I am not sure if this has been done or if even possible, but I figured I'd ask. We sent out a fillable form that was created in excel for multiple people to fill out. They then email this form back. The issue I am having is trying to find a way to pull data from these forms into one master spreadsheet. Currently, we manually enter this data into a master spreadsheet, but I wasn't sure if there was a way to make this less painful. In short, wanting to gather data from multiple forms (same format, different answers) and compile it into a single spreadsheet.
- peiyezhuBronze ContributorMs Form is an online form for collecting information.
Alternatively,you can consolidate multiple excel files to one sheet by sql or VBA coding.