JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER

E

ETTIENE

Joined
Nov 12, 2019
Messages
3
Reaction score
1
HI THERE
IS THERE A WAY I CAN JUMP FROM THE SEARCH CELL TO THE RESULT OF THAT SPECIFIC SEARCH? ALL THE SEARCH CELL DOES IS HIGHLIGHT THE RESULT IN THE RANGE I HAVE NAMED AND FORMATTED(CONDITIONAL) FOR THIS.

FOR EXAMPLE:
NAMED RANGE = A2 TO C10 (DATA IN CELLS ARE NUMBERS 1 - 30)
SEARCH CELL = E1
IF I TYPE "17" IN TO SEARCH CELL(E1) AND PRESS ENTER, IT HIGHLIGHTS B7(17). INSTEAD OF DONG THIS I WANT IT TO JUMP FROM THE SEARCH BAR TO B7 WHEN I PRESS INTER. BASICALLY I WANT IT TO JUMP TO THE CELL THAT I SEARCH FOR NOT JUST HIGHLIGHT IT.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel JUMP FROM SEARCH BAR TO RESULT 3
Excel Conditional Formatting 1
Excel Help to copy information from one row at a time to another sheet 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Excel If a Cell Contains a Certain Text (From Another Table) 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
Excel Macro to automatically go to the right of the last colored cell 0
Active cell is to jump from one cell to another when conditions are met 2

Top