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...
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.
k you Hans. I will take a look
Nigel