aggregating multiple spreadsheets help needed

[steveqt]

Hi everyone,

Here is my problem:

Lets say I have 600+ separate excel files containing 3 tabs. The primary sheet is formatted as a form that has 100 questions on it. All the sheets follow identical formatting.

The idea is to have some kind of tool/function/query/macro that allows me to answer queries based on an aggregate of all 600+ files. For example: Which sheets had a "FALSE" value on question #35?

All suggestions are welcome on how to start solving this problem.

Thank you ahead of time for any input or suggestions. I'll monitor this post regularly so I will respond asap if any more info is needed.

 

[Jerry Sullivan]

Hi and Welcome to MrExcel,

One option would be to use a macro to consolidate all the data on one worksheet.

Ron de Bruin has a free Add-In that provides a simple user interface for common data consolidation scenarios.
RDBMerge, Excel Merge Add-in for Excel for Windows