Filter Macro when Criteria Changes Daily.

[Sam]

I am using Excel 2007 and I need to set up a macro/code to filter
items, copy them to a new worksheet and save them as the filtered name
with date. This needs to be run everyday but the items that need to be
filtered can change each day. Sometimes they will be there and
sometimes they won't.

I’m having issues with the code for the filtering.

Any help will be appreciated.

 

[Don Guillett]

I am using Excel 2007 and I need to set up a macro/code to filter
items, copy them to a new worksheet and save them as the filtered name
with date. This needs to be run everyday but the items that need to be
filtered can change each day.  Sometimes they will be there and
sometimes they won't.

I’m having issues with the code for the filtering.

Any help will be appreciated.

You did post your xl version but neglected to post YOUR code for
comment and suggestions.