I have the following scenario:
In a specific directory individual data spreadsheet files get stored. All the files have the same format.
There is also a consolidation spreadsheet (in a different directory), which is supposed to gather specific information from those data files and move them to an archive directory once they are processed.
Skills: vba, microsoft excel