View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
terry terry is offline
external usenet poster
 
Posts: 193
Default autocreating hyperlinks in excel? ie 500 cells to 500 hyperlinks?

Ive set up a spreadsheet, that acts as a database. I have an index list of
qoutes that hyperlink to the actual spreadsheet quote. But each time i need
to create a new qoute I need to manually assign (hyperlink) one of these
quotes to the index. Is there anyway to do this automatically?

thanks