I have more than 50 000 records of data in 5 columns -I need a macro to ask to enter 3 digits(3 variable digits) then search across the columns(E-I) going down for 3 matches if 3 matches was found it must go to the match....if a second match is found it must go to the next match(can press space bar to go to next match) -so it must jump to all the matches of the 3 digits. The matches must be in the horizontal column (E-I)
Rep given to anyone that can help with a time saver to find the 3 matches.Sample attached to show you the data going down
Bookmarks