MACRO TO FILTER dates.

Closed
Sunir Meethal - Mar 25, 2010 at 12:14 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Mar 25, 2010 at 04:54 AM
Hi All

Could someon ehelp me with a macro to filter dates. I have in place a form created to store the start date and end date onto two cells. All i need is , to filter a colum say 12th colum which lists out dates So after the filter is applied i need to have all rows that have dates between the start and end date.

Say for a week between 23 and 30th, i nee dto have all rows with dates of 23,24, 25,...till 3oth and remove others.

i know its not a tuf nut to crack for u guys. All help would be appreciated..

Regards

Sunir Meethal

2 replies

Sunir Meethal
Mar 25, 2010 at 12:17 AM
The form created is just to input the start date and end date so that their may be applied as criteria for the filter. say i got the form to submit the start and end dates onto Sheet1.Cells(2, 45) and Sheet1.Cells(2, 46) respectivley for start date and end date.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Mar 25, 2010 at 04:54 AM
0