Aug 30 2022 03:22 AM
I created a sample Form with data in the DATA sheet.
How can I write a code that displays automatically (without press Enter or etc), the rows of existing data in DATA sheet whose date of birth is between two dates entering in the TextBox From and To?
It does not matter if this form is in the Form sheet in Excel or in a UserForm1 (Alt + F11).
file attached.
I asked this question also in
https://urlis.net/x526n
https://bit.ly/3AxG3Ij
Aug 30 2022 04:46 PM
@niksirat With Excel 365 you can use the following formula.
=SORT(FILTER(Table2,(Table2[Date]>$B$1)*(Table2[Date]<$B$2)),2)