Previous Topic Next Topic

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
Related:

2 replies

Answer 1 / 2
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
Answer 2 / 2
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 25, 2010 at 04:54 AM
have you looked at this

https://ccm.net/forum/affich-252843-filter-the-data-in-excel-through-formula
0