PC Review


Reply
Thread Tools Rate Thread

Can I filter by something not in a field

 
 
Roger Dodger
Guest
Posts: n/a
 
      25th Nov 2010
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


 
Reply With Quote
 
 
 
 
Don Guillett Excel MVP
Guest
Posts: n/a
 
      25th Nov 2010
On Nov 25, 2:08*am, "Roger Dodger" <gtsmonaro...@bigpond.com> wrote:
> 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."
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Field Filter vs. Number Field Filter on same table AndyC Microsoft Access External Data 0 19th Apr 2011 03:13 PM
Filter Field Selection from Previous Field Jason Lopez Microsoft Access Forms 2 19th May 2009 03:58 PM
Field filter =?Utf-8?B?Q3JhenkgQUw=?= Microsoft Access Forms 1 22nd Nov 2006 09:26 PM
Filter one field by another field in datasheet view =?Utf-8?B?VG95cw==?= Microsoft Access Forms 0 1st Aug 2006 03:21 PM
How to filter data in a field based on user entry in other field =?Utf-8?B?QWxwaGFiZXRh?= Microsoft Access Form Coding 2 11th Jan 2005 06:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:17 PM.