I have been trying to create a macro to automatically save invoices and increase the invoice number each time I save, but I can't make it work. I am a newbie to macros and VBA, so please excuse me if I make dumb mistakes.
Here is a screen capture of the sheet.
Ideally, I would like to:
- Save this sheet only as "F20-nnnn" as a PDF file in a specific location on my PC
- Increase the invoice number in G6 by 1.
Is it possible?
Thank you in advance!