Buttons to run formulas

leebauman

Board Regular
Joined
Jul 1, 2004
Messages
138
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
 

Forum statistics

Threads
1,077,784
Messages
5,336,327
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top