How to automatically copy cell with hyperlink from one sheet to the other

Hey guys, girls,

I have an Excel file with (for the sake of this sample) with two worksheets:

Index
Week32

In week32 I have the invoice number in cell B19. To this cell I add a hyperlink which link to the pdf file of the invoice.

In the Index sheet I have a summary of all the weeks.

I would like to add in the Index sheet the invoice number (with the hyperlink) automatically in the right place, (in this sample it wil be J4).

If no invoice number has been written yet in the week sheet the macro should do nothig, if there is an invoice number it should automatically puts it in the correct cell on the index page with the hyperlink.

My point is to have at the end of the year the index page full with all invoice numbers in the correct cell and that i would be able to open the pdf file by clicking on the link in that cell.

I add a sample file for the convenience.

I hope someone can help me find the solution for this.

many thanks in advance

Urenregistratie.xlsm

Sorry, forgot to add that I have found a sample code that might be usefull but I have no idea how to use it

Please Login or Register  to view this content.