I need to make an invoice system to do the following things, if you could help me with any of the points I'd be extremely grateful! I've numbered them so you can let me know which point you are referring too. Thanks for reading this far!
1. A drop down menu with company names. Another worksheet stores company name, address1, address2, postcode, country. When you choose a company name, the address is automatically added below.
2. To generate the invoice number, a drop down list (a code for each service) and a number (+1 from the last invoice).
3. If poss, to automatically name the work sheet by the invoice number.
4. A new invoice button, that (obviously) opens a new invoice.
5. An automatically updating date cell.
Phew! Any help on any point would be great, thank you!:)