filter several criteria the paste to new sheet

Can an Expert provide me with VBA code that will filter several criteria then copy all of the data selected and copy to a new sheet.

Sheet Range is A-K

So filter column 'I'

criteria is Jan, Apr, Jul, Oct

Copy all data in filter

Paste to Sheet Consolidated.

Thank you
JagwarmanAsked:
Who is Participating?
 
aikimarkCommented:
You will need to use the advanced filter for this.  I added a criteria range on sheet3 and changed your filterit() routine.  The result is placed on sheet4.
TestFile.xlsm
0
 
aikimarkCommented:
Please post a workbook with a representative sample of data
0
 
JagwarmanAuthor Commented:
I got that to work with the months but I cannot get it to work when I am using > in the filter criteria.

Please see attached file.

Thanks
TestFile.xlsm
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.