Combining One Product with Many Variations then going to next product

[kikboxr777]

Hello All,

I am a noob but some experience with Excel but I am having a major brain fart right now. I have a product which I need to combine with many different variations.

Column A would be the SKU for the product and Column B would be 20 different colors. What I need to do is take SKU1 and add a dash and combine with the first color. Then take the SKU1 and add to second color until it is does all twenty colors. Then I need have it go to the next row (SKU2) and do the same thing until it does about 100 different SKUs with 20 different colors...essentially creating 2000 products.

A B
SKU1 GREEN
SKU2 BLUE
SKU3 RED
SKU4 YELLOW
......

Results I am looking for:

SKU1-GREEN
SKU1-BLUE
SKU1-RED
SKU1-YELLOW
SKU2-GREEN
SkU2-BLUE
SKU2-RED
SKU2-YELLOW
SKU3-GREEN
SKU3-BLUE
SKU3-RED
SKU3-YELLOW
and so on.

Any help would be appreciated.

Thanks

Mike

[nathansav]

I think VBA would be best for this

[kikboxr777]

How would that work. I am not familiar with VBA.

[nathansav]

Please Login or Register  to view this content.

[kikboxr777]

nathansav - YOU are the Bomb! Thanks for the Quick Response. That made it SUPER easy. Thanks for the help!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.