Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mango
 
Posts: n/a
Default 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   Report Post  
BrianB
 
Posts: n/a
Default


Assuming that the data you supplied is consistent, you will need some
sort of lookup table like this (used "code" to align columns):-

Code:
--------------------

desc material code Desc2
SHELL PLATE SA516 21110 CARBON STEEL - SHELL PLATE
SHELL PLATE SA516 21110 CARBON STEEL - SHELL PLATE
SKIRT SUPPORT SA516 21130 CARBON STEEL - SKIRTS/SAD
FLANGES SA709 21180 STAINLESS STEEL - FLANGES
GASKETS SA123 21520 BOLTS/NUTS/GASKETS/SPARE
GASKETS SA123 21520 BOLTS/NUTS/GASKETS/SPARE

--------------------


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=273116

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 06:33 PM
Baffling formula problem Ken Schmidt Excel Discussion (Misc queries) 2 December 21st 04 08:52 AM
Paper Tray selection Problem, Michael Hoffmann Excel Discussion (Misc queries) 4 December 3rd 04 10:08 PM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 05:45 PM
Matching a List Containing Redundant Values Rick Hess Excel Discussion (Misc queries) 1 November 26th 04 03:39 PM


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"