Alright thanks for your Help and taking ur time, I will tell you my set up right now, I am not very good at explaining things so i will put in as much details and examples as i can.
I sell 1 item but there are a bunch of accessories that go with it, I use this sheet to control the accessories so i know what i have available when i go to list another item. The "Used" column are accessories that i am using in current auctions, i dont take them off the In Stock section until they are sold.
Now my set up right now goes like this
I have 4 columns that hold information and they go in this order
In Stock / Used / Remaining / Sold
The formula i am using right now is in the remaining cell. Its subtracts "In Stock" from "used" and the final number shows up in remaining. So "remaining" is using the following formula for example =B2-C2.
What i want to do is when i add a number to "sold" i want the numbers in In Stock and Used to go down
Ex. I start with having 3 In stock, 2 used, with 1 remaining and 0 sold.
When i add 1 to the sold column i want it to read 2 In stock, 1 Used and 1 Remaining
if i add more stock i still want it to calculate what is remaining. for example if i am showing 2 Stock, 1 Used 1 remaining and 1 sold then i add 10 to In Stock it should read 12 Stock, 1 Used, 11 Remaing, 1 Sold. And then If i add to Used it should read 12 Stock 3 Used 9 Remaining.
So basically what i want is when i make a sale that is paid for i want to be able to just enter the number of sold and it will subtract that number from the first 2 columns but the remaining cell will still subtract the difference on In stock and Used.
I hope i explained this right and dont confuse you, Let me know if this makes sense and if this is possible?
|