[geohacker]

Ok, I've got an Excel question.

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.

Thanks!
George
[email protected]

[Advertisements]

If you don't get an answer here
try
excell help

[peterm]

If you don't get an answer here
try
excell help

[geohacker]

Thanks, hopefully someone here can help...? I hate Microsoft support...

[peterm]

That is NOT microsort support it is a group of people like us who help
But tend to specialise in Office sortware. It just links through a microsoft web site because microsoft know how good they are

Edited by peterm, 15 June 2005 - 05:47 PM.