Creating data for my system inventory

I am a manufacturer and the problem lies is that I have about 1,00,000 sku in my manufacturing unit.
the items are such as:
1) density, colour, thickness, size and so on.

my sku is like if I have 4 density, 3 colour, 5 sizes so a different sku needs to be created for each of them. Example:

density: 20,22,24,26
colour: red, blue, green
thickness:3, 4, 5, 6 ,7.....
sizes:78*72,78*70,36*22,36*54,55*56.....

I need a help in creating data like:
20 red 3 78*72
22 red 3 78*72
24 red 3 78*72
26 red 3 78*72

after this for each color, then each thickness, then each size. so please help me with a simple formula for the same.

Hi uditgoyal

Welcome to the forum.

I am sorry, but I do not know of any "simple formula" that will achieve what you ask. In fact, I do not know any complicated formula that will do it either!

I can do it using a macro, which I attach.

If you have not used macro before, it may be necessary to amend your macro security settings. Go to File > Options > Trust Centre > Trust Centre Settings > Macro settings

Let me know how you get on

Regards
Alastair

Thanx for the reply...it solves my problem!!!

Hi uditgoyal

I am really pleased that it works for you! Perhaps you will mark this thread as "Solved"? To do this, go to your first posting where you are able to amend the title.

Regards
Alastair