Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
checking return receipt AJ Excel Worksheet Functions 0 March 20th 09 01:59 AM
Donation receipt form Montana Excel Worksheet Functions 7 February 12th 08 09:41 PM
lookup inventory to a receipt lauras03 Excel Discussion (Misc queries) 1 April 10th 07 08:08 PM
how to print a receipt wolfmasterr New Users to Excel 1 June 1st 05 08:58 PM
receipt template MLP Excel Worksheet Functions 0 February 1st 05 02:41 AM


All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"