Hi everyone,
I have a quotation and invoice template, with a register for each and a client data base in one workbook. My code transfer the main data i.e. date, document number, client & amount from each invoice/quote to each register respectively. When the document is saved, it save a copy of the quote or invoice as a new sheet with the document number as the sheet name.
I would like to assign a hyperlink/quick access link to each of the document numbers on the register Automatically, to open that sheet when clicked on, instead of searching through all the sheets for it.
I hope this makes sense. Can add the code if needed.
Thanks in advance.
I have a quotation and invoice template, with a register for each and a client data base in one workbook. My code transfer the main data i.e. date, document number, client & amount from each invoice/quote to each register respectively. When the document is saved, it save a copy of the quote or invoice as a new sheet with the document number as the sheet name.
I would like to assign a hyperlink/quick access link to each of the document numbers on the register Automatically, to open that sheet when clicked on, instead of searching through all the sheets for it.
I hope this makes sense. Can add the code if needed.
Thanks in advance.