Thread: Numbering Invoice
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Numbering Invoice
You will need to employ a little VBA.

See John McGimpsey's site for code.

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


Gord Dibben MS Excel MVP

On Fri, 21 Jul 2006 13:03:01 -0700, DaveO
wrote:

Is it possable to have Xcel set up so that every time you open it to print an
invoice the invoice number is one more then the last one?

Thanks Dave

Gord Dibben MS Excel MVP
Reply With QuoteReply With Quote