Excel Hyperlink

[BoB01]

I'm using Excel to list all my cd albums.. A's the B's Etc. Before every letter change I'm inserting a capital letter at the beginning:
A
aaa
abb'
accjk
B
baff
bsfsh
Etc..
Then across the top I'm linking the capital letter to the apropriate letter ABCDEF etc. The problem is that when I link the B to the B it asks for the cell referance eg. A31.. If I then insert a line to enter an album in the A's then when I use the hyperlink B it's still using the cell referance A31 but it going to the cell above the B. Is there a way of linking the B to B C to C etc. so it doesn't matter how may lines you insert, it'll always link to the apropriate letter??

[Renée]

I can't think of a way to do this with hyperlinks, because your Headers (A, B, C,...etc.) and CD Titles are all in the same column. Therefore, there is no way to anchor your Headers as you add new rows.

The only thing I can think of is to create buttons at the top of the page instead of hyperlinks. Assign a macro to each button that searches for the letter you want. For the letter "A," the macro would look like this...

[quote]
Cells.Find(What:="A", After:=ActiveCell, LookIn:=xlValues, LookAt:= _
xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _
True).Activate
<hr></blockquote>

You'd have to copy that macro 26 times and replace the What:= property with each letter. Assign each letter button at the top of the page its appropriate macro. Doesn't seem worth doing unless you have thousands of CD titles, and if that's the case, I'd recommend putting them in a small database anyway.

Maybe someone else knows an easier way, but this is all I could think of at the moment.