Drop Downs, Index Match or what?
the materials and diameters are adapted except all GRPSN materials
because I don't get them sorted. You have to add another character or
number to the data table that the different values can be recognized.
Regards
Claus B.
Looking very nice. I'll get after finishing it now that I have some solid and proper code to look as example.
But how will you Excel or VBA tell what is str25GRPSN300 or
str50GRPSN300. I guess you have to change the values for that material
into the data table.
So I need to go to the worksheet list and do something like:
For the 300 Dia.
GRP SN 2500 STIS-30
GRP SN 2500 STIS-30
For the 350 Dia.
GRP SN 2500 STIS-35
GRP SN 2500 STIS-35
And so on.
Thanks for the additional direction.
Howard
|