Subtracting a quantity value when entered in sales WB from r - Page 2
Subtracting a quantity value when entered in sales WB from r
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: Subtracting a quantity value when entered in sales WB from r

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    ...

  2. #12
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #13
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #14
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  5. #15
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    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?

  6. #16
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #17
    Board Regular
    Join Date
    Mar 2002
    Posts
    122
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com