How to make a receipt or invoice so that the receipt Nos. change automatically
 

Please is there any way in excel to make a receipt so that the receipt
number will automatically change on printing or after pasting a copy?
Is it also possible to use Quick Parts in Excel? Thanks.

How to make a receipt or invoice so that the receipt Nos. change automatically
 

Couple of sites to check out.

John McGimpsey for sequential invoice numbers

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

Ron de Bruin might have something useful for printing same invoice with
sequential numbers.

http://www.rondebruin.nl/print.htm#same

I think Quick Parts is just for Word and Outlook but not sure about that.


Gord Dibben MS Excel MVP


On Mon, 16 May 2011 08:05:44 -0700 (PDT), capitokk wrote:

Please is there any way in excel to make a receipt so that the receipt
number will automatically change on printing or after pasting a copy?
Is it also possible to use Quick Parts in Excel? Thanks.