Hello:

I am very new to VBA. Very, very new. I need help creating a macro that will do the following:

I have one folder that contains hundreds of excel files. Each excel file contains multiple worksheets. Within each worksheet, I would like to count data that meets specific criteria, and compile the counted data into a Summary worksheet within a separate Summary workbook.

The columns for the Summary Worksheet would be as follows:
Column A: Name of Worksheet
Column B: COUNT IF Column C of above worksheet>0 and Column D="needs spacer"
Column C: COUNT IF Column C of above worksheet is blank and Column D="needs spacer"
Column D: COUNT IF Column B of the above worksheet="yes"

Also, while the number of workbooks within the folder will not change, the data within the worksheets may change over time (as the project progresses). It would be helpful if the macro counted new data without changing what its already counted (is that default? Told you, I'm new here!)

Thanks!!!