Can I filter by something not in a field

  • Thread starter Thread starter Roger Dodger
  • Start date Start date
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
 
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
Click to expand...

"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."
 
Back
Top