vba form search by multiple criteria

[Ana Luna]

Hello, I am trying to resolve the "Find" bottom in the vba form attached but with no result. You can see it in the ribbon start/start and a form appears.
The point is that the button has to find by 1 , 2 or 3 concepts. It has to check one by one if concepts are empty, if they not the code must apply the filter in the correspondent column in the sheet called "final" and copy the entire row with coincidence in the sheet named "Seleccion".
As you can see, I almost got it (some code works).
Thank you so much for your help.
(all the information in the attached file is invented)
Regards,

 

[Frank2021]

Hi Ana,

Please, check it out

Regards

'-----
Hola Ana,

mira si así te vale

Saludos

 

[Ana Luna]

It's incredible, even better than I had imagined. Thank you so much Frank. The search button for 3 fields doesn't seem to work. I am attaching the form again with two new buttons: one to search by 3 fields and the second one to search by 4 fields.
I am studying your previous code and comparing it with mine.
Could you please be so kind to help me with the two buttons I mentioned above? This way, I can learn. Thank you.

 

[Frank2021]

Hi @Ana Luna ,

I enclose my proposal for filtering rows.
Please study all functions located in Module2 and function "find_click" located in Form
I hope you like it

Regards