Creating automatically Hyperlinks

Hi,

In my worksheet , I have column A where names of PDF files are automatically created. How can I automatically add a
hyperlink to every PDF? ( meaning after adding the name of the file, a link would be created to this file)

Thank you,

Daniel

How are the PDF filenames automatically created? Do they include the file path?

Could we see and example workbook?

BSB

The new file is an invoice template. I am making an invoice with a xlsx extension and pasting automatically data from my main workbook to the “invoice” file

The name of the new xlsx file is based on the invoice number and the name of the customer (data in a row in my main workbook)

Please Login or Register  to view this content.

The new invoice file opens and a cell with the invoice name is automatically created in my main workbook ( same row as previously)
I am looking a way to add a hyperlink to this cell.

Daniel