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
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