MACRO TO FILTER dates. Closed

Question

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

Sunir Meethal · Answer

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.

rizvisa1 · Answer

have you looked at this

https://ccm.net/forum/affich-252843-filter-the-data-in-excel-through-formula

MACRO TO FILTER dates.

2 responses

Similar discussions

Subscribe To Our Newsletter!