Hi All,
I will try an be as clear and specific about my "issue" and what I would like to do. I am dong invoices and quotations in excel. Every quote has a serial number and of course each invoice. I would like to set up so that when a user sets up a new quotation in excel a serial number is generated automatically in the serial number order. For instance => MJ -Quote-201601-001, MJ -Quote-201601-002 etc
I usually then have a hyperlink from this quote to the invoice which is linked to this quotation.
Question:
1. Shall I use some IF formula for generation of automatic sequential numbering or do I need some VBA magic here?
2. Can the hyperlink be automated somehow so I do not have o manually go and select each invoice from a separate location. For instance if the invoice number would be highlighted oin the quotation sheet, could there be some automated link that updates the hyperlink?
I know I might not eb entirely clear here, but any suggestion here would be much appreciated.
Thank you
Markus
Bookmarks