Hey people, first timer here. Didn't exactly know where to put this, so
I followed the big red typing...

Anyway, currently, we use excel to create UPC codes for our products.
I was wondering how to make it more streamlined, and possibly
automatic...

Let me explain how it works. Columns A-F are six seperate fixed
numbers that correspond to our six digit vendor code. Then, in cells
G-K, we have a 5 digit number, starting at 30001 that gets one bigger
for each UPC (30001, 30002, 30003, etc).

There are several more issues I need to address later about making this
UPC code generator automatic, but for now, I would like to know how I
can make excel generate consecutive numbers for the last 5 digits.
Each digit must be in a seperate column, and it has to create a 5 digit
number (30001, 30002, 30003, etc).

Thanks for your help, if you can answer this one, I will give you a
more challenging one later...

KillerTofu


--
killertofu
------------------------------------------------------------------------
killertofu's Profile: http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=506922