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
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