I have a spreadsheet setup like a database. At the top of the page I have an entry block where I type in a name. Using the Vlookup function, it returns the row number the person is located at in the spreadsheet. Works great!
Now, I want to take it a step further... Is there a way to have a button / macro that would read the contents of the search result and have the screen relocate to that position? Basically, I type in a name...it says its row 2000, then I click on the button/macro and it will jump to that location (instead of me scrolling forever to get to the person).
If anyone knows a function or way I can script such a macro...please let me know.