default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 180
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hey guys,
I am trying to get some inputted cell values to change, based on values in another column.
Explanation:
There are two columns of values, a Bucket and Actual.
The bucket value represents an amount that is 'in the bucket'. Each bucket value can vary or change depending on the user input.
As the Actual value increases, the Bucket value decreases.
This can be achieved by simply using a subtraction formula in the Bucket cell.
(see below for a visual)
However, I am looking to make this workbook a little bit more intuitive so that the user does NOT need to set up the Bucket formula every time.
Is there a way (possibly using VBA?) to automatically have the Bucket values (in column A) change depending on the Actual values (in column B)?
Basically, it would be nice to just be able to type in the value of 40 into A2 and have it decrease by whatever is placed in B2 (without having to enter in the =40-B2 formula into A2)
Is something like this even possible?
Thanks in advance
I am trying to get some inputted cell values to change, based on values in another column.
Explanation:
There are two columns of values, a Bucket and Actual.
The bucket value represents an amount that is 'in the bucket'. Each bucket value can vary or change depending on the user input.
As the Actual value increases, the Bucket value decreases.
This can be achieved by simply using a subtraction formula in the Bucket cell.
(see below for a visual)
A | B | |
1 | Bucket | Actual |
2 | 40 (=40-B2) | |
3 | 15 (=30-B3) | 15 |
4 | 50 (=100-B4) | 50 |
However, I am looking to make this workbook a little bit more intuitive so that the user does NOT need to set up the Bucket formula every time.
Is there a way (possibly using VBA?) to automatically have the Bucket values (in column A) change depending on the Actual values (in column B)?
Basically, it would be nice to just be able to type in the value of 40 into A2 and have it decrease by whatever is placed in B2 (without having to enter in the =40-B2 formula into A2)
Is something like this even possible?
Thanks in advance