Hello, I want to build a simple sheet to manage inventory for rental business with 3 warehouses. Items can be pulled from, and return to any warehouse.
When the quantity of items is entered, I want some kind of button to appear where I can choose which warehouse the items will pull from (initial date) and return to (end date). If I use the button to elect to pull items from a particular warehouse, I need the warehouse stock to decrease by the amount entered. Conversely, if I use the button to elect to return items to a particular warehouse, I want the warehouse stock to increase by the amount entered.
I also want to color-code the quantity entry to indicate which warehouse the items will be pulled from, and which warehouse the items will return to (blue for Warehouse A, red for Warehouse B and green for Warehouse C, for example).
Is all this possible?
Excel 2016 (Windows) 32 bit
When the quantity of items is entered, I want some kind of button to appear where I can choose which warehouse the items will pull from (initial date) and return to (end date). If I use the button to elect to pull items from a particular warehouse, I need the warehouse stock to decrease by the amount entered. Conversely, if I use the button to elect to return items to a particular warehouse, I want the warehouse stock to increase by the amount entered.
I also want to color-code the quantity entry to indicate which warehouse the items will be pulled from, and which warehouse the items will return to (blue for Warehouse A, red for Warehouse B and green for Warehouse C, for example).
Is all this possible?
Excel 2016 (Windows) 32 bit
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | Warehouse and current inventory | | | Job and number of widgets | | | ||
2 | Date | A | B | C | 1 | 2 | 3 | |
3 | 1/1/2019 | 120,000 | 50,000 | 200,000 | | | | |
4 | 1/2/2019 | 70,000 | 50,000 | 100,000 | | 50,000 | | 100,000 |
5 | 1/3/2019 | 70,000 | 50,000 | 200,000 | | 50,000 | | |
6 | 1/4/2019 | 120,000 | 15,000 | 200,000 | | | 35,000 | |
7 | 1/5/2019 | 120,000 | 15,000 | 200,000 | | | 35,000 | |
8 | 1/6/2019 | 120,000 | 50,000 | 200,000 | | | | |
9 | 1/7/2019 | 120,000 | 50,000 | 200,000 | | | | |
10 | 1/8/2019 | 120,000 | 50,000 | 200,000 | | | | |
11 | 1/9/2019 | 120,000 | 15,000 | 200,000 | | | | |
Sheet: Sheet1 |