Sequentially increasing invoice number when opening workbook, without macros? (Excel 2008)

[x10an]

Hello,
I see many posts regarding sequentially increasing numbers (i.e. for an invoice) by using visual basic and macros. But my Excel 2008 for Mac does not support macros, is there a formula way to work around this?

Thanks a lot in advance!

 

[nashgas]

I don't know much about the Mac version but I did find this:

http://www.realgeek.com/forums/automatic-sequential-numbering-394506.html

see if that helps with what you need

 

[nashgas]

or maybe this will work:

[FONT=Courier, Monospaced]For invoice numbering you could insert the date and use the format (example 13:21) every time the document is opened a updated number will appear. Unfortunately the number will not be sequential, but the numbering can be useful.

source:
http://groups.google.com/group/micr...l/browse_thread/thread/620db3911dbc2a0e?fwc=1
[/FONT]

 

[Fazza]

hi,

I don't know about Mac 2008 version, but this tests OK in Excel 2003.

Make a table. I used header "A_List" and immediately below that a value 1.

Give this defined name "whatever". Save the file.

Add a query table. Excel 2003 is via menu ALT-D-D-N and follow wizard to the end. Then choose the option to edit in MS Query and edit SQL to become

SELECT A_List + 1 AS [NextValue]
FROM whatever

Set the queries properties so that the query refreshes on file open.

In the A_List cell where you initially entered 1, change that to =1+'the cell returned from the query'

Voila. Each time the file opens the query refreshes automatically and the number increments by one with no VBA used.

HTH

 

[x10an]

Thank you very much for your replies!
I finally went for the option nashgas proposed with date and time, as this turned out to be quite useful and at the same time unique as a reference.

 

[littledib]

Hey. I am trying to do exactly what you have said here, but I am rather a novice at excel so was wandering if you could explain where I start with it or even if you could send me an example file so I can get my head around it.

Im basically trying to get a template to open with a sequential number increasing each time, but I'm using Excel 2008 for Mac so the VBA isn't compatible.

Cheers

hi,

I don't know about Mac 2008 version, but this tests OK in Excel 2003.

Make a table. I used header "A_List" and immediately below that a value 1.

Give this defined name "whatever". Save the file.

Add a query table. Excel 2003 is via menu ALT-D-D-N and follow wizard to the end. Then choose the option to edit in MS Query and edit SQL to become

SELECT A_List + 1 AS [NextValue]
FROM whatever

Set the queries properties so that the query refreshes on file open.

In the A_List cell where you initially entered 1, change that to =1+'the cell returned from the query'

Voila. Each time the file opens the query refreshes automatically and the number increments by one with no VBA used.

HTH