Autofilter Multiple Workbooks by Date

mrmagoo321

New Member
Joined
Aug 9, 2010
Messages
2
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

jbeaucaire

Well-known Member
Joined
May 8, 2002
Messages
6,012
'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.

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

New Member
Joined
Aug 9, 2010
Messages
2
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

Well-known Member
Joined
May 8, 2002
Messages
6,012
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.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,972
Messages
5,514,511
Members
409,004
Latest member
EdwardBaker

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top