Good day everyone
Is there a way to write a formula that will load information from x number of workbooks automatically?
This is the scenario:
I have a folder named "reports"
in this folder I periodically download reports of raw data. I name these files in the following format "Raw january 2012", "Raw february 2012", and so forth. In the same folder I want to have an excel file called "output", that automatically extracts info from these files and summarize them for me.
Here is an illustration of what I want to do:
Lets say that every Raw data report I download into that folder has a column heading at cell A5 called "values"
I want to write a formula in, say cell A3 of "output" that will look for all workbooks with file name that starts with file name "Raw"
and load all of their collective datas on cells A5 and below and return these values.
for better illustration, this is what would be below cell A5 in raw files
Raw january 2012
a
Raw february 2012
b
Raw march 2012
c
a
this is the result I want to get starting at cell A3 of the file called "output"
a
b
c
a
That way whenever I download "Raw april 2012" this information will autopopulate into my output report as soon as I open it.
Any help would be greatly appreciated.
Thank you!
Bookmarks