|
|
#1
02-06-2017, 10:01 AM
|
|||
|
|||
simple inventory sheet "i think"
Hi everyone i need help doing this simple inventory, i really have no clue on how to do it. ask me anything about alarm and cctv systems and i will be able to help but when it comes to excel im the biggest dumb at it.
so i have already figured out how to add from cell quantity E, tech1 F, tech2 G and come up with total at total H, what i want to be able to do is if i add tech1 "F" x amount it will automatically subtract from "E" quantity and the same for tech2 "G" and show the total in "H" Quantity is what i have in stock at the office tech1 is what he has in there truck tech2 is what he has in there truck total is my overall stock 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Threaded Mode