Auto Number

[Keith]

I would like for Excel to Auto number Sales Orders for
us, but keep up with them incrementally. The Numbers are
formatted as follows: ABC000XX (Where is X will be the
numbers auto enumerated.). We would like for it to
Automatically insert the numbers. The Theory is that we
will be able to use the numbering scheme all the way up
ABCXXXXX (Where X is autonumber incrememntally.).

Can thi sbe done in Excel? Thanks, Keith

 

[Frank Kabel]

Hi Keith
how do your store your differen sales orders?
Are they allstored on one worksheet and you want to increment for
example column A you may use the following formula in A1:
==IF(B1<>"",ROW(),"")
copy this down for all rows.
After this format column A with the custom format
"ABC"00000

 

[Keith]

Frank, thanks for getting back with me. We stor the
sales ortders individually as "Sales Order ABCXXXXX". I
am using an Excel form to do our Sales Orders.

I would like for the Sales Order Number (in Cell B9) to
auto generate, so that we don't have to keep up with them
manually. If I had a copy of Access, I feel like I could
probably do it in Access, but we do not have a copy of
Access at my disposal.

I feel like there should be a way to do it in Excel, I
just don't know how to make it go up incrememntally. Any
insight would be greatly appreciated. Thanks, Keith.