Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: PLEASEEE SOME1 ANSWER THIS QUESTION!!!!

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

    Default

    its the backbone of my project! Im doing 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
    Thank you.

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Don't know if this helps. But if you use the paste special command. Under opertaion it says 'Subtract'. You could use this to subtract your quantity value from the stock value.

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

    Default

    The paste special command would work for this purpose but I am assuming you want something more automatic than that,a nd for every entry made, for it to automatically update the stock worksheet?

    Yes a lookup/if statement would work for it to automatically subtract the sales qty from the stock qty.

    It's very difficult without data infront of me to properly understand though.

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

    Default

    HELEN UR A GENIOUS! plz heres some more data!!!:

    The sales workbook looks like this:

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

    Column C = Product Name, Column D = Price,

    Column E = Quantity, Column F = Cost.

    When the quantity is entered i would like to no how this quantity is subtracted automatically from the Stock workbook which looks 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.

    Thanks a lot but i REALYYYY need this for my project.

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

    Default

    ...

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sami,

    Do you have a sheet of samples for me to work with, I find it so hard to understand what people mean when they try and write their problem.

    I will send you my personal e-mail address in a private message, and if you want to I can help you that way?

    Helen

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

    Default

    hey helen i got another message the same as this around the first few pages - its a long one - my names anomous on it. could i email you the project bcos its in for nxt week :S

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

    Default

    anyone???? :S

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

    Default

    ...

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

    Default

    im really serious i cant finish without doing this. can any one out there help?

Some videos you may like

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
  •