I have hundreds of Excel files (databases) from which I want to extract a subset of variables.
The data are not systematically in the same cell (e.g. G4) and also don't always start on the same row. However, they do have the same variable name. The titel of the file contains a date which I would need to extract as well.
I am basically looking for a way to get all values under a certain variable name within a file in a single file.
What would be the easiest approach to combine all sheets in a single database ? Using Macro's? All tips/links are very welcome.