SITUATION: I HAVE 2 EXCEL FILES ONE IS CALLED “MARKET AND THE SECOND ONE IS
“PRODUCT”
“MARKET”
SKU Price Quantity
123606 $295.00 8
123606 $295.00 8
124258 $149.95 85
124258 $149.95 85
123849 $149.95 116
123849 $149.95 116
112060 $99.95 0
112060 $99.95 0
123883 $79.95 2
123883 $79.95 2
124469 $34.95 0
MARKET HAS “SKU”, “PRICE” AND “QUANTITY”.
“PRODUCT”
ItemNo ItemPrc1 ItemQtyOnHnd
100016 16.5 267
110030 11.95 1,652
110710 19.95 40
112060 99.95 0
123606 295 8
123849 149.95 116
123883 79.95 2
123949 24.95 231
PRODUCT HAS “ITEMNO”, “ITEM PRICE” AND ITEMONHAND”.
THE PROBLEM: IS “MARKET NEEDS TO BE UPDATED USING THE “PRODUCTS” DATA BECAUSE
THE ITEMPRICE AND ITEMONHAND CHANGES AND IF YOU NOTICE SOME OF THE MARKET’S
SKU’S VALUE IS DOUBLE HOW DO I AUTOMATE THIS USING VBSCRIPT?