Part Number Generator

Hi
I have a series of various part numbers to create from a set of categories.

What I want to do is have a formula / VBA that will make a part number from the options.
At the minute I've started copy/pasting the numbers.
Is there a way to get this done without copy/pasting?

I have added an example sheet to the post.

The options are in highlighted section at the top and the table below is the start I have made.

Thanks
Kieran

It is not clear to me what constitutes a"Part Number": you appear to have combinations of the different components (a possible 3888 in total).

Me being dim here!

Originally Posted by JohnTopley

It is not clear to me what constitutes a"Part Number": you appear to have combinations of the different components (a possible 3888 in total).

Me being dim here!

No you're correct


a part number would be iTCPPF2200, iTCPPPF220I etc

Originally Posted by Bo_Ry

Please try at A23:H23

=INDEX(A2:A10,MOD(INT(SEQUENCE(PRODUCT(MMULT(TRANSPOSE(ROW($A$2:$H$10))^0,N($A$2:$H$10<>""))),,0)/MAX(1,PRODUCT(MMULT(TRANSPOSE(ROW($B$2:$H$10))^0,N(B2:$H10<>""))))),COUNTA(A2:A10))+1)

Thank you Bo_Ry!! :D
That's great, now need to match the descriptions to these part code bits, i'd hid the descriptions on that sheet in the highlighted area.
I'll have a go at those now.

Originally Posted by Bo_Ry

Please try at A23:H23

=INDEX(A2:A10,MOD(INT(SEQUENCE(PRODUCT(MMULT(TRANSPOSE(ROW($A$2:$H$10))^0,N($A$2:$H$10<>""))),,0)/MAX(1,PRODUCT(MMULT(TRANSPOSE(ROW($B$2:$H$10))^0,N(B2:$H10<>""))))),COUNTA(A2:A10))+1)

I've copied the formula into my sheet and (ctrl,shft,ent) on the cell and now getting a #name error?

Originally Posted by Bo_Ry

If you use MS365 then update your MS office.

If not then

A23
=INDEX(A$2:A$10,MOD(INT((ROWS(A$23:A35)-1)/MAX(1,PRODUCT(MMULT(TRANSPOSE(ROW($B$2:$H$10))^0,N(B$2:$H$10<>""))))),COUNTA(A$2:A$10))+1)

Ctrl+Shift+Enter and copy over to all

Thanks got it working now