Forum Discussion
filtering date query
You might use a userform with a text box. You can then filter the data in the Change event of the text box, so that the data are filtered as you type.
Showing all data if I1 is blank seems reasonable, but if you wish we can hide all data.
See the attached workbook - I hope that it works on Mac. You will have to allow macros.
You might use a userform with a text box. You can then filter the data in the Change event of the text box, so that the data are filtered as you type.
Showing all data if I1 is blank seems reasonable, but if you wish we can hide all data.
See the attached workbook - I hope that it works on Mac. You will have to allow macros.
can't seem to see the attachment?
I have recreated the workbook. To avoid it being removed again, I have uploaded it to Dropbox:
The forum has removed the attachment. 😡
k you Hans. I will take a look
Nigel
