Combine Product List and Attribute List

Hello Excel Forum,

I'm new to VBA and the forum, but I have a task in Excel that I'm looking for some wisdom about how to approach. I want to take data from a list of products, and data from a list of additional attributes of these products, then combine the data into a table where each discrete product has its own row.

My example below is a simplified version of what I want to do. I hope it helps to understand my question. My real data is much larger and more complex. Does anyone have a good idea about how to approach something like this?

Thank you.
Stasi
Sample.xlsx

example1.png

Please attach an Excel sample file to help for VBA

I updated my original post to include a sample file.

Clear thank you

Are "Input Table" and "Additional Parameters" table always with the same criterias and nb of rows ?

Are th number of columns always the same:
Material 1" length price 1.5" length price 2" length price
Pitch Head Style Length

Yes, for the input table, the number of columns will always be the same.

and for "Additional Parameters" the same : Pitch Head Style Length

The key between "Input Table" and "Additional Parameters" is still the "Length" ?

Today in your "Output Table" the criteria order is:
1 - Material
2 - Length
3 - Head Style
4 - Pitch
Is it always the same ?

To make it easy I suggast to change column order in "Outout"
"Material Length Head Stylle Pitch" ... and others to come and at the end "Price id"
is it OK ?

See here what could be done.
Have a look on the file attached to see adjustments done

Please Login or Register  to view this content.

Yes, test and retest
Thx for the Rep.