Nov 29 2023 12:25 PM - edited Nov 29 2023 12:28 PM
I know this has been asked before, but I'll be darned if I can find a suitable answer.
I have a drop-down list of names in cell Z3 (created with data validation).
Currently I have a conditional format to color the cell with the name selected from the drop-down to simplify the search.
My wish is to select a name from this dropdown list, then automatically jump to the text-matched cell.
I want to keep it simple without using macros - I'm positive there's a way - maybe using hyperlink, but I haven't figured it out.
Here's a screenshot:
Nov 29 2023 12:31 PM
Nov 29 2023 12:37 PM