show automatically rows of created data between two dates

Copper Contributor

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

1 Reply

@niksirat With Excel 365 you can use the following formula.  

 

=SORT(FILTER(Table2,(Table2[Date]>$B$1)*(Table2[Date]<$B$2)),2)

DexterG_III_0-1661903006835.png