Autofilter Multiple Workbooks by Date

[mrmagoo321]

Hi all,

I am new to this forum but I have some good experience with excel.

I am working on a project that tracks data by date on various different worksheets (10 different sheets)

The final worksheet is used as a SUMMARY. Currently it is used to input any date and tally how many events took place that day. However, once this date is set, all of the other worksheets must be filtered manually to give an accurate summary.

I was wondering if there was a script or macro that could be used to filter all of the worksheets by date when a new date is set in the SUMMARY worksheet.

Please let me know if this question has already been answered in this forum, else any help would be appreciated.

Feel free to MSG me if you need some more specifics.

Thanks in advance

 

[jbeaucaire]

'MANY SHEETS TO ONE SHEET
I have a macro that may be "almost ready to use" for merging data from multiple sheets into a "consolidation" sheet.

Sheets to One Sheets - Part 1​

The highlighted section in the middle is where you would customize it to apply your autofilter right before you copy into the consolidation summary sheet.

========
For more specific assistance customizing the macro above, turn on the macro recorder and let it record you selecting your Summary sheet, entering the date in the correct column, then switching to one of your other sheets and applying the date filter.

Post the resulting code and I will tweak it into the customization section of the macro.

 

[mrmagoo321]

thanks for your response.

I should have stated that the worksheets carry different information and are not formatted the same. (date column is different in most worksheets). The summary sheet has a field that tracks daily and continuous stats of each individual worksheet.

I think the record macro will help I will try that first thing tomorrow and post the results.

thanks again.

 

[jbeaucaire]

The sheet referenced above has as second macro on it aimed at collecting data from worksheets in differing, but similar, formats. Check out PART two.