vba filter dates
 

Hi Folks,
I use to have this code but forgot it... I need to filter coulmn F less than
or equal to todays date, and greater than or equal to todays date minus 7
days. I had the code that would do that but alas it's gone...
Thanks for any help..

vba filter dates
 

Turn on the macro recorder and perform the action manually. Use a custom
criteria and pick two dates (doesn't really make any difference which two).


Turn off the macro recorder

Now adjust the recorded code to apply the criteria you want.

--
Regards,
Tom Ogilvy

"Duncan_J" wrote in message
...
Hi Folks,
I use to have this code but forgot it... I need to filter coulmn F less
than
or equal to todays date, and greater than or equal to todays date minus 7
days. I had the code that would do that but alas it's gone...
Thanks for any help..

vba filter dates
 

Hi Tom how are you doing?
Thanks for all the help in the past..
I'm just using =today() in the far right coulmn and beside that a coulmn
with =P2-F2 format the coulmn for numbers and filter less than or equal to
7... Works good enough...
Have a good weekend...
DJ
"Tom Ogilvy" wrote:

Turn on the macro recorder and perform the action manually. Use a custom
criteria and pick two dates (doesn't really make any difference which two).


Turn off the macro recorder

Now adjust the recorded code to apply the criteria you want.

--
Regards,
Tom Ogilvy

"Duncan_J" wrote in message
...
Hi Folks,
I use to have this code but forgot it... I need to filter coulmn F less
than
or equal to todays date, and greater than or equal to todays date minus 7
days. I had the code that would do that but alas it's gone...
Thanks for any help..

vba filter dates
 

Can't beat that with a stick <g

--
Regards,
Tom Ogilvy

"Duncan_J" wrote in message
...
Hi Tom how are you doing?
Thanks for all the help in the past..
I'm just using =today() in the far right coulmn and beside that a coulmn
with =P2-F2 format the coulmn for numbers and filter less than or equal to
7... Works good enough...
Have a good weekend...
DJ
"Tom Ogilvy" wrote:

Turn on the macro recorder and perform the action manually. Use a
custom
criteria and pick two dates (doesn't really make any difference which
two).


Turn off the macro recorder

Now adjust the recorded code to apply the criteria you want.

--
Regards,
Tom Ogilvy

"Duncan_J" wrote in message
...
Hi Folks,
I use to have this code but forgot it... I need to filter coulmn F
less
than
or equal to todays date, and greater than or equal to todays date
minus 7
days. I had the code that would do that but alas it's gone...
Thanks for any help..