LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #15   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,365
Default Auto Number in Invoice

Pammi J,

Disregard the _Rev02 that you received today - contains 3 'show stopper'
errors in code. My apologies - that's what I get for trying to rush
something out the door without adequate testing. Have repaired the code,
will get working version to you this evening, along with suggestions for how
to set up your customer list for ease of data entry.

JLatham

"Pammi J" wrote:

Hi
hope someone can help me. I have an invoice i have designed and the last bit
i need before i use it is to assign a invoice number to the template and have
it automatically increase by one everytime - ie 101 would be 102 on opening
the next time.
i have read McGimpseys page and used the code - i put it in the this
workbook part but its not doing anything. Have i got the right code or do i
need any other bits to go with it? Also i dont understand what `text` file i
need - as its saying to create one? and what is default path as string - is
that where i type where my template is. Sorry im a newbie to invoice
numbering. but i only need this and then i can move on to other things.
many thanks



 
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
Trying to do a auto number generater EricHiew Excel Worksheet Functions 2 May 2nd 06 04:14 AM
Generate Auto Order Number cher Excel Discussion (Misc queries) 1 March 28th 06 06:15 PM
Auto Number horseman Excel Discussion (Misc queries) 2 November 24th 05 04:28 PM
Auto number invoices in Excel Fay Excel Worksheet Functions 1 September 12th 05 04:43 PM
assign auto number and auto date Krit Kasem Excel Discussion (Misc queries) 2 January 14th 05 02:55 AM


All times are GMT +1. The time now is 10:26 PM.

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"