Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching problem using VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching problem using VBA
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. -- Regards, Tom Ogilvy "tango" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching problem | Excel Discussion (Misc queries) | |||
Matching Problem Possible? | Excel Discussion (Misc queries) | |||
A matching problem | Excel Worksheet Functions | |||
matching problem using VBA | Excel Worksheet Functions | |||
Matching problem.... | Excel Programming |