Another option besides a macro is to have named ranges. Read up on
those and see if it would solve your problem. Then all they have to do
is use the F5 key for "go to" and pick the name range they want. There
are ways to build named ranges from lists so it is somewhat simple.
Another method is to have a list and create hyperlinks. You can also
create drop down lists. Macros can be as easy or as complicated as you
need, but some end users get "freaked" when they see the "Enable macros"
choice when a file opens. A simple macro would be to designate an input
cell (they would enter the account in this cell) and then your macro
would do a find in a designated area and go-to that cell. Sounds like
you need to have a list first though. Turn on the macro recorder and
start with something simple. If it works, expand it to your specific
situation. That's how I taught myself.

TcO


--
tcowen
------------------------------------------------------------------------
tcowen's Profile: http://www.excelforum.com/member.php...fo&userid=6921
View this thread: http://www.excelforum.com/showthread...hreadid=494691