View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] lhkittle@comcast.net is offline
external usenet poster
 
Posts: 168
Default 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