Excel number auto increment help!

Hi, I'm totally new to VBA and no nothing about it other than how to copy and paste code in. I've been trying to design an invoice where the number increases. I have so far managed to get code working from my template that increases the number every time the template is opened however if i open an invoice i have already done it still increases the number on that invoice.

The code i'm using is:

Please Login or Register  to view this content.

So basically i want the number to increase each time on the template but not on saved invoices. I know there are many topics about this already but i really have no idea how to adapt code to make it work for my worksheet. So could any help please be explained to me step by step.

thanks in advance

Hi

To keep things simple you can set a cell value to control the increment, for example

Please Login or Register  to view this content.

Regards

Jeff

Hi Jeff, That's perfect, exactly what i needed. Thanks again!