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
Bookmarks