Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Need Macro Help please


  • Please log in to reply

#1
geohacker

geohacker

    New Member

  • Member
  • Pip
  • 2 posts
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
GeoHacker@hotmail.com
  • 0

Advertisements


#2
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
If you don't get an answer here
try
excell help
  • 0

#3
geohacker

geohacker

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
Thanks, hopefully someone here can help...? I hate Microsoft support...
  • 0

#4
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
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.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP