Creating UPC Codes...

[killertofu]

Hey people, first timer here. Didn't exactly know where to put this, s
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 possibl
automatic...

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

There are several more issues I need to address later about making thi
UPC code generator automatic, but for now, I would like to know how
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 digi
number (30001, 30002, 30003, etc).

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

KillerTof

 

[Guest]

I think this might work for you:

Manually enter the number in cells G1:K1. Then, enter the following
formulas in cells G2:K2. Copy down as many rows as you need.

G2 = MID(CONCATENATE(G1,H1,I1,J1,K1)+1,1,1)
H2 = MID(CONCATENATE(G1,H1,I1,J1,K1)+1,2,1)
I2 = MID(CONCATENATE(G1,H1,I1,J1,K1)+1,3,1)
J2 = MID(CONCATENATE(G1,H1,I1,J1,K1)+1,4,1)
K2 = MID(CONCATENATE(G1,H1,I1,J1,K1)+1,5,1)

Note: This will give the results as text. If you need the results to still
be numbers, then just put the above formulas within a VALUE() function.

=VALUE(MID(CONCATENATE(G1,H1,I1,J1,K1)+1,1,1))

HTH,
Elkar

 

[killertofu]

Winner, winner, chicken dinner...

Thanks homes, you're a genius. You shoulda seen my previous formula
that were in there. IF within IF within IF. It was messy.

Speaking of concatination, if you have time, do you think you coul
explain what the function is actually doing? I'm one of those peopl
who has to know why it's working