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??