link_location from contents of cells
 

currently we use the combined contents of two cells i.e.=B45&"-"&B48".pdf" to
name the pdf file used in a Hyperlink, When our sales staff updates one of
these two cells I would like it to update the Link_location to direct the
hyperlink to the correct file.