Hi Sure I will help you on this. Can you share a dump file for me to understand it more precisely ? Sorry for the late reply.
Hello Daksh, I've done some pretty easy spreadsheets in the past, but don't know how to use Macros. I want to create an Excel invoice with a macro that generates the next invoice number automatically. So whenever I save an invoice and re-open the invoice spreadsheet again, the next invoice number automatically loads. At the moment, I'm manually adding the next number, but sometimes I forget to change it and this is a real problem if you don't realise until after you've printed subsequent invoices. I'm using Excel Mac 2008. Do you know anywhere that I can get a template with the macro already loaded? I've seen the formula for doing what I want to do, but have no idea how to apply it.
