Jump to Cells

[skander]

I am working with a large spreadsheet (10000+ rows) and I would like to have a group of cells at the top of the sheet (a legend) that would allow me to navigate the sheet faster. Data is organized by month with between 200-750 rows of data per monthIdeally it would act something like a hyperlink in that you could just click on a cell in the legend and the cursor would jump to the cell that was named in the legend. Example:

Legend
Month Starting cell
Jan A2
Feb A560
Mar A1287

etc.
So if I click on the cell that says A560, the page jumps to A560. Note: I am not looking to return the value in A560, I was to go there (so that I don't have to drag the whole sheet around when I am working in row 7000).

[ChemistB]

You can use Hyperlinks/Bookmarks to achieve what you want to do. For example, with Cursor in Cell A1, Insert Hyperlinks. Then click on Bookmarks, the appropriate sheet, then type in the cell number (e.g. Sheet1!A500). In the "Text to Display" Type "January 07". and then OK.

Does this work for you?

In general, you can type any cell number in the "Name Box" (toolbar lefthand side) and hit enter and you'll be there.

ChemistB

[Richard Buttrey]

Hi,

Name the range of cells that contain your cell references, (those containing A2,A560,A1287) above as 'MyLink'

Now in the Worksheet_SelectionChange event enter the following:

Please Login or Register  to view this content.

Rgds

[skander]

ChemistB, works great, thanks!
Hexaflexagon, thanks for posting too, I will keep that in mind, but Chris had a simpler method