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

[capitokk]

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.

 

[Gord Dibben]

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