Popup that provide the filter options

For some unknown reason, if I were to choose the cell value from the input box window, the code does not pick the date, but If I manually type the value in the box, it works.

Thanks for you reply. I dont exactly see what your macro does.

I made my excel file a bit more clear hope it helps

The pop box asks you to type the cell address. It then copies in to column K.

When I type in for example B4 what is 18 Oktober I do not get the kinfo of that date.

Is it also possible to not copy the data but only select this option in the filter?
Thanks

That was exactly the first code does. It does not copy, but just filter the data, but you need to remove the last line which removes the filter

Please Login or Register  to view this content.

You need to type the date as it appears on the cell

Ok this works better but can you please give an example what I can fill in in the Pop Up, because I get cannot get any result form the filter.
Thanks fopr your help!

For e.g, if you want to filter by 17-Oct, when the box pops up, you need to type 17-Oct
I know, Ideally, you should click the cell when the box pops up and not need to type it, but it is not working. I need to come back to with on this, but in the mean time, just type the cell address you want to filter by.

is it not possible to enter date in cell and that he uses that cell as reference for filter selection?
Thanks!

Well, that was my intention, but I do not know why the filter does not pick-up the date.

Please Login or Register  to view this content.