excel search bar help

[Imran Azam]

Hi Guys

i am creating a application with excel which has a user interface that allows you to search which membership is about to expire within 3 months based in the dd-mm-yyyy typed in the search bar

example if

if you type nov 2022 in search bar and press apply button below comes up

	City	Address	membership Joined	Renewal Date
BB	leeds	AAA	01/01/2022​	01/01/2023​
AA	leeds	AAAA	01/01/2022​	01/12/2022​

can this be done? would be grateful for any help ( i dont know how to attach a excel file but i have inserted imagines below, and the data)

below is the data i am working with

	City	Address	membership Joined	Renewal Date
BB	leeds	AAA	01/01/2022​	01/01/2023​
AA	leeds	AAAA	01/01/2022​	01/12/2022​
CC	leeds	FFFF	01/01/2022​	01/01/2024​
DD	leeds	12	01/01/2022​	01/01/2023​
EE	leeds	EEE	01/01/2022​	01/02/2025​
FF	leeds	1233	01/01/2022​	01/08/2023​
GG	leeds	2132131	01/01/2022​	01/08/2023​
HH	leeds	1312	01/01/2022​	01/08/2023​
YY	leeds	1312	01/01/2022​	01/08/2023​
TT	leeds	133	01/01/2022​	01/08/2023​

from this data i want to create the below front end ( below is based on the example if november 22 is typed in the search box this isnt working at the moment)

 

[sijpie]

there are several ways to do this:

1. You can create a filter in VBA, or
2. you can use the advanced filter in Excel.

in the second case your button only needs to copy the entered date +90 days to the criteria range with a '<' in front, then apply the filter.

In the first case the table can be read into an array, then a loop goes through the dates in the array and copies those rows that fulfill the less than 90 days.

 

[Imran Azam]

there are several ways to do this:

1. You can create a filter in VBA, or
2. you can use the advanced filter in Excel.

in the second case your button only needs to copy the entered date +90 days to the criteria range with a '<' in front, then apply the filter.

In the first case the table can be read into an array, then a loop goes through the dates in the array and copies those rows that fulfill the less than 90 days.

Thank you for your reply and help, where can i get more information regarding the vba filter route?

 

[sijpie]

right here. What I would like from you is the name of the sheet with the data and top left cell of the table, the name of the sheet with the output and top left cell of the output table.

 

[Imran Azam]

right here. What I would like from you is the name of the sheet with the data and top left cell of the table, the name of the sheet with the output and top left cell of the output table.

Thank you so much sheet name with data : Data top left cell A1 ( that is the cell above BB) l, sheet name with output: FrontEnd the top left cell for this is A7 ( this is above BB) . is this the correct info you needed?

how can i attach a full data sheet on here?