simple inventory sheet "i think"

moedope · #8 02-06-2017, 01:05 PM

Quote:

Originally Posted by Chellebell1689

Oh, I think I see what you mean...

100 - 20 - 30 = 50, right? (just an example)

So basically E would be the total you want, F and/or G is how many you have, then H is what's still needed. I just want to make sure I understand properly.

no
E is stock in office
F is inventory held by tech1
G is inventory held by tech2
H is overall stock be E,F,G
if i give F or G inventory i want to subtract from E "office" and still have total in H
i already have E,F,G added to H and when i subtract inventory from F and G my totals are correct in H but its not subtracted from E

ive updated pic because the first one had wrong imputs
also attached the file

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ADODB import of Excel data results in "Run-time error -2147467259: <sheet> is not a valid name."	misaak	Excel Programming	3	06-20-2016 07:55 AM
How to remove the "Delete" option when I right click on sheet tab - HELP HELP HELP	barryoffshore	Excel	2	06-23-2014 04:57 AM
Resources "Available From" Date in resource sheet	bluphoto	Project	3	04-05-2012 09:33 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
"Inserting" 11x17 blank sheet into report	mcjohn	Word	2	01-06-2010 09:14 AM