How do I auto increment cell value on print in Excel
 

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.

Take a look he

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



In article ,
"Hiren" wrote:

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.

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

"Hiren" wrote in message
...
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.

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

--
Don Guillett
SalesAid Software

"Hiren" wrote in message
...
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.

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


"Hiren" wrote in message
...
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.

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" wrote:

Take a look he

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



In article ,
"Hiren" wrote:

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.

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

In article ,
"Hiren" wrote:

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?

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,


"JE McGimpsey" wrote:

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

In article ,
"Hiren" wrote:

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?