Buttons to run formulas

[leebauman]

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
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td][/td][td]

Warehouse and current inventory​

[/td][td]

​

[/td][td]

​

[/td][td=bgcolor:#808080][/td][td]

Job and number of widgets​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td]

Date​

[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td=bgcolor:#808080][/td][td]

1​

[/td][td]

2​

[/td][td]

3​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

1/1/2019​

[/td][td]

120,000​

[/td][td]

50,000​

[/td][td]

200,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

​

[/td][td]

​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

1/2/2019​

[/td][td]

70,000​

[/td][td]

50,000​

[/td][td]

100,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

50,000​

[/td][td]

​

[/td][td]

100,000​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

1/3/2019​

[/td][td]

70,000​

[/td][td]

50,000​

[/td][td]

200,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

50,000​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

1/4/2019​

[/td][td]

120,000​

[/td][td]

15,000​

[/td][td]

200,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

​

[/td][td]

35,000​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

1/5/2019​

[/td][td]

120,000​

[/td][td]

15,000​

[/td][td]

200,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

​

[/td][td]

35,000​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

1/6/2019​

[/td][td]

120,000​

[/td][td]

50,000​

[/td][td]

200,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

1/7/2019​

[/td][td]

120,000​

[/td][td]

50,000​

[/td][td]

200,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

1/8/2019​

[/td][td]

120,000​

[/td][td]

50,000​

[/td][td]

200,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

11​

[/td][td]

1/9/2019​

[/td][td]

120,000​

[/td][td]

15,000​

[/td][td]

200,000​

[/td][td=bgcolor:#808080]

​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]