Need formula that links cell names with corresponding file name in folder

[Menlow]

I have an excel workbook which contains info on all credit notes we issue a month, the colunms are: Date, Credit Note No., Relating invoice, Amount, Reason and Account. I also have a folder (C:\Documents and Settings\My Documents\Credit Notes) which contains all the credit notes in pdf format which are named by their credit note no. to match the excel sheet. Currently i am manually matching the hyperlinks to the corresponding file, but this is taking up far to much time. I was wondering if their is a formular i could use which would automatically match the cell name with the pdf file and create a hyperlink for each credit note.

Many Thanks
Ben

 

[JazzSP8]

Hi Ben - Welcome to the board

You should be able to build a hyperlink with the hyperlink function, for example...

=HYPERLINK("C:\Documents and Settings\My Documents\Credit Notes"&"\"&B1&".pdf")

Assuming your credit note number is in B1, if not amend to suit

Hopefully that makes sense to you...

 

[Menlow]

Works a treat!!

Thanks so much, it's much appreciated.