To Merge Range of Data
 

Is anybody could help me on the following, fill in the Pri File data in
master file:
*If the material is the same than look from Pri File (W) which will be
greater than Master file (W)
Mater File
Material W L Pri File (W)* Pri File (L)* Pri File(Qty)
BVHZM005 5 645
BVHZM005 6.8 590
ZM006 9 620
BVHZM005 15 15
ZM006 15 25
BVHZM005 70 70
ZM006 70 1000
ZM006 100 1000
BVHZM005 100 1000
ZM006 125 625
BVHZM005 125 1000
___________________________________________
Pri File
Material Width Length qty
BVHZM005 145 620 67
BVHZM005 150 620 53
BVHZM005 150 1000 4
BVHZM005 165 1000 3
BVHZM005 168 1000 9
ZM006 145 620 67
ZM006 150 620 53
ZM006 150 1000 4
ZM006 165 1000 3
ZM006 168 1000 9