View Single Post
  #4  
Old 06-11-2007, 04:20 PM
BeaucoupFish BeaucoupFish is offline
Senior Member
 
Join Date: Jun 2005
Location: San Francisco
Posts: 723
Default Re: Excel Help Needed

Depending upon how many cells you are listing, define a name for each cell first (Insert | Name | Define, or type in the new name into the cell address box, as a shortcut). Have the hyperlink link to the name instead of the address.

The link will be retained during any sorting, cut/pasting or otherwise moving of the cell(s).
Reply With Quote