link_location from contents of cells

J

JimiC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
how to design spreadsheets to collect data and display the totalmaterial used in a plating departmen 13
Which MS Program to Use? 0
Copying diagonally opposite value from the known cell/range. 1
Problems created by Recent updates to Outlook 365 0
Copy text from cell and paste it in a separate text box (contents tobe linked) 7
Copy the contents of a range of cells to a single comment(indicator)? 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top