accounting student needs your help in scripting

upeastrye · Post by **upeastrye** » Wed Nov 21, 2007 8:27 pm

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 SO IT UPDATE ITSELF?

Me_again · Post by **Me_again** » Wed Nov 21, 2007 10:07 pm

Can't you just use VLOOKUP ?

Post by **Marcus Tettmar** » Wed Nov 21, 2007 10:38 pm

Is your caps lock key stuck?

Me_again · Post by **Me_again** » Thu Nov 22, 2007 12:20 am

mtettmar wrote:Is your caps lock key stuck?

Thanks for writing what I was thinking

upeastrye · Post by **upeastrye** » Fri Nov 23, 2007 12:04 am

sorry about the caps =/.. so could anyone help me about my problem? its actually a finals for my class.. Pls help me =/

Me_again · Post by **Me_again** » Fri Nov 23, 2007 12:14 am

I did. See above. Not sure what you learn by asking for the answers to your schoolwork on the internet

upeastrye · Post by **upeastrye** » Fri Nov 23, 2007 12:55 am

so is there anyway i could update the other file by just using the other file?