Software

Ask something
Question Locked

accounting student needs help from vbscript experts

0 helpful
5 replies

by bluerhi_03

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

5 replies

by thumbsup2

Well, do you know vbscript yet? If not, I suggest you hire someone to do it for you. The programming can get extensive and it's not something we could do for you for free. But, I can give you some ideas for the logic.

(1) you want to update MARKET from PRODUCTS, so put the macro in MARKET.

(2) set variables to represent all of the column and row place holders, all of the data items, counters, etc...

Then, read data into variables from first row of MARKET. Search PRODUCT for same item number (comparing variables) and, if found, store values from PRODUCT in variables then replace the contents of the appropriate cells in MARKET from those variables.

It takes looping through both MARKET (one time) and PRODUCT many times (each time a new item # is encountered). Once the MARKET data is updated, then you have to do it the other way around, looping through PRODUCT one time and checking to make sure that item number is listed in MARKET, adding new rows to MARKET to the bottom of the list when necessary then going back to the top again. Then, you have to decide what to do with records listed in MARKET but not PRODUCT and vice versa... do you add them, erase them?

As you can see, it's not something we can whip out off the top of our heads in just a few minutes. You need to hire an expert.

by bluerhi_03

maybe i was just too overwhelmed I didn't really realized that it would be as complex as that. This was given as an exercise by my professor so I'm assuming it would not be that hard since I'm still in my freshmen yr. but i guess not.. =/ Thank you for your time for giving me an idea on how to make it and for your time. Have a wonderful thanksgiving to you and to all. GOBBLE GOBBLE

by hiral12

Email me your assignments and I will send you back the solutions. In addition to solving problems I do projects, papers and essays.
I offer assistance in the following areas, undergraduate, graduate and post graduate levels:
Accounting
Accounting concept
Income statement
Balance sheet
Cash-flow statement
Accounts receivable, Note receivable
Inventory
Fixed Assets, Depreciation
Intangible assets
Current liability
Bond
Long-term liability
Common and preferred stock
Treasury stock
Cash and dividends
Financial statement analysis
Cost accounting, Cost analysis
Accounting and management decision
Budgeting
www.homeworkhelpindia.com
prashant8778@yahoo.co.in

This discussion is closed to new replies.