Can I filter by something not in a field

R

Roger Dodger

Hi all,

I have a macro that filters different columns of a sheet. One of the things
that it filters is a column called last used date. At the moment I have set
it to filter custom - anything after 4th august.

Is there a way that I can get it to only give me the data for the last say
month or fortnight?

Your help as always is greatly appreciated
 
D

Don Guillett Excel MVP

Hi all,

I have a macro that filters different columns of a sheet. One of the things
that it filters is a column called last used date. At the moment I have set
it to filter custom - anything after  4th august.

Is there a way that I can get it to only give me the data for the last say
month or fortnight?

Your help as always is greatly appreciated

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top