How to write a macro to filter data in excel according to input box

I have data in excel that are imported from SQL. I would like to write a macro that allow the user to input a specific day and month in input box so the data which is already exist in excel will be filtered according to that day and month
Rawan JambiAsked:
Who is Participating?
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
Filtering is a standard feature in Excel so why do you need to use a macro to run it.

If the data already has AutoFilter enabled, there will be a dropdown at the top of each column. Select the drop down at the top of the date column and it should group the data by year, month and date so the user should be able to easily select the filtering required.

Thanks
Rob H
0
All Courses

From novice to tech pro — start learning today.