How do I auto increment cell value on print in Excel

[Guest]

I am trying to creat an invoice template using Excel 2002. My purpose is to
auto increment the invoice number whenever I make a new invoice.

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

 

[JulieD]

Hi Hiren

if you'ld like to email me direct (julied_ng at hcts dot net dot au) i
have a sample invoicing workbook which you might be able to customise to
your needs or get some ideas from etc.

alternatively (or as well) check out
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Cheers
JulieD

 

[Don Guillett]

One way would be to put it in the before print event of the ThisWorkbook
module.

 

[Paul B]

Hiren, have a look here for how to do it

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Hello JE McGimpsey,

Thanks for the instant help. However whenever the workbook template is
accessed for a new invoice generation, it give a runtime error which when
debugged points to
With ThisWorkbook.Sheets("Invoice")
line of the code. I m not sure if I m doing it correct as I dont use macros
regularly but this code has been saved in ThisWorkbook window, under open
event. Is this OK?

 

[JE McGimpsey]

The location is OK. Change the sheet name to your worksheet.

 

[Guest]

Thanks. It does work now.

Is there a book I can purchase and test some sample macros which maybe
useful for my other functions in the invoice?

Rgds,