I am doing a stock sheet with hyperlinks to data sheets.

My method is very long and going to take me forever to do.

the method I follow is right click on the cell, hyperlink insert hyper link, go to the folder where the hyper links are, open the folder and find the sub folder where the datasheet is, select the data sheet and ok.

It works. However its going to take me forever to sort this out so was wondering if there was an easier way.

Also it shows the whole path to open the datasheet. (e.g.. ..\..\Desktop\Stock Data Sheets\CMOS\CD4030.pdf)

Whilst that's not the end of the world I would just like it to look a bit neater. Any suggestions and advice will be great.

Thank you

Rodney