matching problem using VBA

[tango]

Dear All,
I have this problem.
1)how to map each other as the commonly sharing information only by
description but yet not fully mapped. for example, working table desc
is shell plate whereas update table is carbon steel - shell plate.
2) even same material in working table also can have different desc.
notice SA516, same material but different desc.

can anyone out there help me on this?
thanks alot


from this working table do subtotal and.....
desc material price
SHELL PLATE SA516 50
SHELL PLATE SA516 40
SKIRT SUPPORT SA516 30
FLANGES SA709 100
GASKETS SA123 75
GASKETS SA123 20

update in the amount field
code desc amount
21110 CARBON STEEL - SHELL PLATE 90
21130 CARBON STEEL - SKIRTS/SAD 30
21140 CARBON STEEL - PIPES
21170 CARBON STEEL - TUBE SHEET
21180 STAINLESS STEEL - FLANGES 100
21520 BOLTS/NUTS/GASKETS/SPARE 95

 

[Tom Ogilvy]

Think you would need to add a category column to the original data which
assigned it to your summary categories or an equivalency table.

You can put in formulas like

=sumif(Sheet1!A:A,"*shell*",Sheet1!B:B)

but I suspect each would have to be custom built.