Thread: How to make a receipt or invoice so that the receipt Nos. change automatically
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
  
Posts: 621
Default 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.
Reply With QuoteReply With Quote