On my invoice I have a "button" place with a link for customers to click and pay amount. So I don't want the invoice to be a PDF I don't think.. not sure. How do I save and send my invoice to customers so they can do this? Beginner Excel person here.
Yes you could use a simple =___+1 kind of formula. You could probably also use a basic macro. But for something quite small it might be just as easy to update it manually.
great tutorial, thankyou for your kindness. may i know how do iI store and keep all my invoice detail to another sheet automatically after each invoice been created ? can you help ?
Next invoice you will need to go back into the excel template and either copy the sheet into a new tab for the new invoice or edit the current invoice template with the new details, then export to PDF again
