Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I automatically pull a new invoice number into an excel te.
I want to create an invoice template in Excel, each time I create a new
invoice I will save it as a worksheet/workbook. I need a new unique invoice number to be automatically generated each time I open the template. I believe I will need to create some form of database to store invoice numbers but I don't know where or how to get started with this. I looked at data - Import External data but this is grayed out? Can anyone help? Thanks. |
#2
|
|||
|
|||
This question is answered about twice a month.
Go to Google; click on Groups; click on Advanced Group Search In All Words use INVOICE In Newsgroup box enter (with asterix) *EXCEL* I got about 7,000 hits nest wishes Bernard "Hube" wrote in message ... I want to create an invoice template in Excel, each time I create a new invoice I will save it as a worksheet/workbook. I need a new unique invoice number to be automatically generated each time I open the template. I believe I will need to create some form of database to store invoice numbers but I don't know where or how to get started with this. I looked at data - Import External data but this is grayed out? Can anyone help? Thanks. |
#3
|
|||
|
|||
Thanks,
I'm taking a look now. It seems that the old functionality that Excel use to suuport (invoicing tools etc) are all gone. I'm working on a mac, I guess I will end up writing a vba script that will maintain a file that stores numbers (not my preffered solution as I haven't done that in a while...) If I knew Access I'd probably give that a go as then I could also store address information etc... Thanks, Hube "Bernard Liengme" wrote: This question is answered about twice a month. Go to Google; click on Groups; click on Advanced Group Search In All Words use INVOICE In Newsgroup box enter (with asterix) *EXCEL* I got about 7,000 hits nest wishes Bernard "Hube" wrote in message ... I want to create an invoice template in Excel, each time I create a new invoice I will save it as a worksheet/workbook. I need a new unique invoice number to be automatically generated each time I open the template. I believe I will need to create some form of database to store invoice numbers but I don't know where or how to get started with this. I looked at data - Import External data but this is grayed out? Can anyone help? Thanks. |
#4
|
|||
|
|||
Hube
Check out J.E. McGimpsey's site. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben Excel MVP On Tue, 28 Dec 2004 12:59:05 -0800, "Hube" wrote: Thanks, I'm taking a look now. It seems that the old functionality that Excel use to suuport (invoicing tools etc) are all gone. I'm working on a mac, I guess I will end up writing a vba script that will maintain a file that stores numbers (not my preffered solution as I haven't done that in a while...) If I knew Access I'd probably give that a go as then I could also store address information etc... Thanks, Hube "Bernard Liengme" wrote: This question is answered about twice a month. Go to Google; click on Groups; click on Advanced Group Search In All Words use INVOICE In Newsgroup box enter (with asterix) *EXCEL* I got about 7,000 hits nest wishes Bernard "Hube" wrote in message ... I want to create an invoice template in Excel, each time I create a new invoice I will save it as a worksheet/workbook. I need a new unique invoice number to be automatically generated each time I open the template. I believe I will need to create some form of database to store invoice numbers but I don't know where or how to get started with this. I looked at data - Import External data but this is grayed out? Can anyone help? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel automatically opens files | Excel Discussion (Misc queries) | |||
how to get week number in month in excel ? | Charts and Charting in Excel | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) | |||
Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) |