Julied

This sheet is to be used for the whole year and we
normally allocate numbers in a book from 1 to appox 550.
On the second click of the command button I would want to
find the next blank line and put the next consecutive
number in there.
This spreadsheet is to allocate a unique batch number for
the year starting from 1.
So at the start of the financial year I would allocate
number 1 to the first batch the 2 to the second then
three and so on.

Thanks
Mark
-----Original Message-----
Hi Mark

how many consecutive numbers would you want to create at
any one time ...
on the second click on the command button would you want
to replace the
number in A2 with the next number after A1 or would you
want to find the
next blank line and put the next consecutive number in
there?
what do you want to happen if someone re-orders the
column .. is the next
number to be generated one more the physically last
number in the column or
one more than the maximum number in the column?

Cheers
JulieD

"Mark" wrote in
message
...
Can I ask someone how I would go about getting the
results I want for the following points.
1. If I wanted to generate consecutive numbers when
I hit a command button how would this be done?
2. How would I get the first number in cell A1 then
A2 and so on?
3. If I want to start the numbers at 457.

Thanks for any help in this matter.



.