Forum Discussion
Solved
filtering date query
I have data in columns A3:E5000 and I wish to filter it based on the values in column B3:B5000 which is a name field based upon the name typed in cell I1. I have tried using the filter function and I get it to work except that if cell I1 is blank with nothing in it the function displays everything....
Also I would like to enhance it so that it's more dynamic so when test is being typed in I1 it is filtering immediately. As I use a mac and the active x controls are not available I cannot do this.
just wondering if anyone has any suggestions
thanks
Nigel
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:
k you Hans. I will take a look
Nigel
