Automatic Invoice/Estimate Number Generator

[ava_h]

I have a spreadsheet that I've created for us to estimate repair costs for customers. I would like for the Estimate # to automatically change everytime they open the sheet to create a new estimate.

The assigned cell is R3. The estimate # can start at 0001. I'm not great at VBA, so step by step would be helpful.

Thanks! PS - I'm using 2007.

 

[XL&ME]

Take a look at MrExcel Podcast #1505. This shows how to generate a new invoice number each time the worksheet is opened. I think this will accomplish what you are looking for.

 

[XL&ME]

Here is a link to podcast #1505

http://www.youtube.com/watch?v=Tj_Ce7LS1Ok