Anchor points or links?

[Lythande]

Hey board,

Is it possible to have something like an internal link within a spreadsheet? i.e. when I click on sheet one there's something of a table of contents on it's first page where I click on, say, Chicago and it zips me down to page 20 where my Chicago data is? I thought this might be better than lots of scrolling or having lots of sheets.

 

[Lythande]

Oh! I found the Go To function via F5...very cool--especially since you can name cells and type it in or click on the list that pops up. Nice. I just zipped around my spreadsheet like a mad man.

Well and good. Still, if there's a way to hyperlink from once cell to another within a sheet it would be worth knowing.

 

[Nalani]

One way that I do it if there is not too many cells to "jump" to:

Insert a few buttons from the Forms Tool Box to the top of your sheet.
Freeze Panes just below the buttons so they always show.

Then assign a macro to each button, similar to this one:

Sub GotoChicago()
   Application.Goto Reference:="R500C1"  'some row and col past all data
   ' so next line will bring the cell to the top left of screen
    Application.Goto Reference:="R280C1" ' cell [B]A280[/B] if that is where you want to go
End Sub

One macro per button with changes to Name, and "jump" to location.

There may be better ways, but this works for me.