Hello community,
I am trying to find the most automated way to solve the following problem:
I receive a variable number of response forms filled in by different people, in the shape of excel files with an identical structure. I want to retrieve some predefined variables from these files and use them in a main excel document, to make averages and statistics.
I would like to minimise the number of actions requiered to link a new response form to the main statisticsfile when I receive one (so avoid having to link every files manually). Ideally, there would be a directory containing all the excel response forms, and the main excel would go through all the files in that specific directory.
For example, imagine a directory containing X excel files with a number written in cell A1, plus a main file that averages all those numbers from the X files. If I add or remove a file to/from the directory, the average is updated.
What strategy would you use to solve this problem?
Thanks for the help! Loïc
