Subtracting a quantity value when entered in sales WB from r

[Guest]

Im doing a Major skool project for my A levels and (this project needs to b an A grade ) I and the rest realllllllllllly need this problem solved bcos were all doin a Stock control system. When a Sale is entered in the Sale workbook how do I get the sale quantity entered to subtract from the Stock quantity in the stock workbook automatically when its entered? i was thinkin something like Vlookuup n IF state ments!>????> :S

 

[Sami]

...

 

[Steve Hartman]

Im doing a Major skool project for my A levels and (this project needs to b an A grade ) I and the rest realllllllllllly need this problem solved bcos were all doin a Stock control system

You first posted this a week ago. Yes, many people on here could do this. Perhaps you should take the lack of response as a message to DO YOUR OWN BLASTED HOMEWORK. ADMIT TO YOUR TEACHER YOU DON"T KNOW WHAT YOU'RE DOING AND GET HELP THERE!

I also think Oxford uni (sic) will probably choose someone with a better command of the english language.

_________________
AAARRRRGGGGHHHHHHHHHHHH!!!!!!!!!!!!!!

Tension Breaker. Sorry,it had to be done
This message was edited by Steve Hartman on 2002-03-11 10:25

 

[Sami]

plz im here to do a project! its the real thing! plz its not homework. can anyone answer the q!!!!

 

[Sami]

hey its not homework this is serious!!! plz some 1 help

 

[Audiojoe]

So what you mean is, suppose you have a figure in A1 (Stock), and C1 is your sales record whatever. You want to put a figure in B1, then have it subtract from A1 and add to C1?

 

[Audiojoe]

Are you there?????

Well, if that IS what you want, then try this:

Cells(1, 1).Value = Cells(1, 1).Value - Cells(1, 2).Value
Cells(1, 3).Value = Cells(1, 3).Value + Cells(1, 2).Value
Cells(1, 2).Value = ""

HTH

 

[Sami]

hey no thats not what i was looking for but thanks anyway. Ive got a Sales workbook set out like this:

Column A = Sale Date, Column B = Product ID,

Column C = Product Name, Column D = Price,

Column E = Quantity, Column F = Cost.

Ive got a Stock workbook set out like this:

Column A = Product Name, Column B = Product ID,

Column C = Price, Column D = Quantity,

Column E = Total Value, Column F = Supplier,

Column G = Re-Order Quantity.

What i really need to know is how when a quantity is entered when there is a sale, say one item of fish food was sold how do i make this automatically be subtracted from the quantity of stock of that particular product in the stock workbook. using the product ids ifs ??? plz i really need help and i only have till sunday!