Generating sequential numbers?

[NickS]

Does anyone have an idea how I might go about creating a macro (or other solution) to enable me to generate a list of sequential numbers?

I want to track an order book in an excel spreadsheet and allocate a new sequential number to each transaction. Naturally I could just do this manually, but given the orders could be spread across several sheets and will be managed from multiple locations I would rather have the numbers created automatically.

The idea I had was to pre-populate all the order numbers and then have the macro pick the next available number at the press of Ctrl and flag the numbers as used. The next time Ctrl is pressed it will pick up the next available number and so on.

I'm not experienced enough with Macros to figure this out, but felt sure someone out there must have had need of something similar?!

Thank you!

 

[JE McGimpsey]

Does anyone have an idea how I might go about creating a macro (or other
solution) to enable me to generate a list of sequential numbers? <br><br>I
want to track an order book in an excel spreadsheet and allocate a new
sequential number to each transaction. Naturally I could just do this
manually, but given the orders could be spread across several sheets and will
be managed from multiple locations I would rather have the numbers created
automatically. <br><br>The idea I had was to pre-populate all the order
numbers and then have the macro pick the next available number at the press
of Ctrl and flag the numbers as used. The next time Ctrl is pressed it will
pick up the next available number and so on. <br><br>I'm not experienced
enough with Macros to figure this out, but felt sure someone out there must
have had need of something similar?! <br><br>Thank you!

See

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

 

[NickS]

Fabulous - many thanks JE!