VBA: how to create search button and create new sheet with found values

[mcf23]

Hello friends,

I have the following problem: I have a large Excel file and would now like to search for values from table 1 (using a search function) with search criteria from columns E, F and H and transfer the values found to a new worksheet (worksheet 2)

The whole thing is supposed to work in such a way that I search for values in the same way as, e.g. with the help of a Userform, and these values are then reproduced.

In addition (if possible), after the search, a ranking should be created, which refers to the values in column I (i).

I could not find any helpful code online. So I would appreciate any help!

Thanks and greets,
Moritz

 

[Fluff]

Duplicate VBA: via search function, transfer data from a table to a different sheet

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).