My Dept has a survey that they send out to members once a year. The data gets submitted to us via an excel spreadsheet/template.
What we'd like to do is be able to offer those that have participated in the previous year's survey the ability to have access to their information they submitted from the prior year. We have about 300 participants in this survey, and the survey could take 2-3 days to finish it from scratch. Each participant has a survey ID so tracking the data should be relatively easy.
Preferably we’d like to import their past year data into the current year’s template; linking their data to the appropriate cells. We know we can do this manually but we receive 300 responses each year and we need to find a way to streamline this process, without having to open each individual excel file.
I'm not an excel guru by any means, but have been asked to help to see if I can aid in making this easier as I'm the sys admin for the department. What is the best route for me to go here?