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