MACRO TO FILTER dates.

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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


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.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768