Aug 14 2019 04:47 AM
Hi everyone, I am wondering if it is possible to filter information with dates, but not the same as usual filter that you have in Excel with dropdown menu.
I HAVE data base where there are a lot of values for different dates, the dates are repited for each unit that we have (touristic apartments names/occupancy/prices/dates).
I NEED take a different dates and need to see data just for this time frame. As you can see at photo, I put 18/8 and the last day when I want to see all data between 18 and 21 of Aug.
And than if I want to change day to any other day (for example from 17of Oct to 28 of Dic), the data should be shown automaticly.
Is it possible to do in Excel?
Kind Regards for any help,
Nelly
Aug 14 2019 04:53 AM
That's if with VBA programming.
About manual filtering is here https://excelribbon.tips.net/T012918_Filtering_Columns