Hello,
I am trying to build a macro that will pop up and act like the text filter ‘contains xyz AND contains xyz. Ultimately, I would like it to use a one drop down box that has letters and one drop down box that has numbers then highlight the corresponding cell. Example: data in column K in one cell shows part 25 :A1, B3, C1...... either pop-up for user that cAn find Part 25 and B3 with ability to reset or when drop down list where A is selected and other drop down list 2 is selected it finds it in the cell. I appreciate any help as I have gone mad trying to get something to work and this is the last piece holding me back. I would like to add it to the ribbon and attach as a button.
I am trying to build a macro that will pop up and act like the text filter ‘contains xyz AND contains xyz. Ultimately, I would like it to use a one drop down box that has letters and one drop down box that has numbers then highlight the corresponding cell. Example: data in column K in one cell shows part 25 :A1, B3, C1...... either pop-up for user that cAn find Part 25 and B3 with ability to reset or when drop down list where A is selected and other drop down list 2 is selected it finds it in the cell. I appreciate any help as I have gone mad trying to get something to work and this is the last piece holding me back. I would like to add it to the ribbon and attach as a button.