Posted to microsoft.public.excel.misc

Malcolm McMaster[_2_] Malcolm McMaster[_2_] is offline

external usenet poster

Posts: 15

Macro driven record locator.

I have a large worksheet containing around 1000 rows of data.Column "A"
contains a unique ID code for each row.I would like to be able to quickly
locate a particular record (Row) by entering the ID code in a cell then
navigate to it by clicking on a button ( coded with a macro) to take the user
to the location specified by the cell contents.
Does anyone have any ideas. Thanksi n advance

Malcolm McMaster

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paramater driven value	Andrew	Excel Worksheet Functions	2	January 29th 08 12:19 PM
What does it mean to record the macro	Liz	Excel Discussion (Misc queries)	6	March 15th 07 07:35 PM
Record New Macro	ju1eshart	Setting up and Configuration of Excel	3	August 25th 06 04:21 PM
Drawing driven database updates	Kennard	Excel Discussion (Misc queries)	1	February 13th 06 03:40 AM
Date driven formula/worksheet	Corey	Excel Discussion (Misc queries)	10	November 5th 05 12:43 AM

All times are GMT +1. The time now is 06:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us