Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Invoice Numbering
How can I set up on invoice on excel to where I get automatic sequential
numbering each time the spreadsheet is opened? |
#2
|
|||
|
|||
Amber,
A simple way would be to use something like this, call it form the workbook open event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Amber" wrote in message ... How can I set up on invoice on excel to where I get automatic sequential numbering each time the spreadsheet is opened? |
#3
|
|||
|
|||
Amber: Try the methods used in this workbook (or just use the workbook).
http://www.officearticles.com/downloads/invoices.zip ************ Anne Troy www.OfficeArticles.com "Amber" wrote in message ... How can I set up on invoice on excel to where I get automatic sequential numbering each time the spreadsheet is opened? |
#4
|
|||
|
|||
Amber
See John McGimpsey's site for help on this. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben Excel MVP On Tue, 27 Sep 2005 13:31:09 -0700, "Amber" wrote: How can I set up on invoice on excel to where I get automatic sequential numbering each time the spreadsheet is opened? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Invoice Numbering
I have tried link below - Mcgimpsey? and got dead end??
Is it just down for moment? "Paul B" wrote: Amber, A simple way would be to use something like this, call it form the workbook open event. Sheets("Sheet1").Range("A1").Value = _ Sheets("Sheet1").Range("A1").Value + 1 For other ways to do this or if this is going to be used in a temple have a look here http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Amber" wrote in message ... How can I set up on invoice on excel to where I get automatic sequential numbering each time the spreadsheet is opened? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invoice Numbering | Excel Worksheet Functions | |||
In Excel, how do I setup sequential numbering on an invoice? | Excel Worksheet Functions | |||
Master invoice number | Excel Worksheet Functions | |||
Invoice Numbering | Excel Worksheet Functions | |||
Invoice Numbering | Excel Worksheet Functions |