Hi
Is there a way to use VBA to find the first value in a column that's greater than or equal to 1, then deduct a value from that cell?
Eg I have a list of Numbers in column D in Sheet 1.
In the simple example below, the title 'Numbers' is in cell D1, and the values 0, 1, 2, and 3 are in cells D2, D3, D4 and D5, respectively.
I'd like to run a Sub which finds the first value greater than or equal to 1 then deducts the value in cell A1 in Sheet 2 from the cell found in column D in Sheet 1.
In this case, the value in cell A1 in Sheet 2 is 1.
I'm sure this is possible, but would be grateful for your thoughts?
TIA
Is there a way to use VBA to find the first value in a column that's greater than or equal to 1, then deduct a value from that cell?
Eg I have a list of Numbers in column D in Sheet 1.
In the simple example below, the title 'Numbers' is in cell D1, and the values 0, 1, 2, and 3 are in cells D2, D3, D4 and D5, respectively.
I'd like to run a Sub which finds the first value greater than or equal to 1 then deducts the value in cell A1 in Sheet 2 from the cell found in column D in Sheet 1.
In this case, the value in cell A1 in Sheet 2 is 1.
I'm sure this is possible, but would be grateful for your thoughts?
TIA
Numbers | |||
0 | |||
1 | |||
2 | |||
3 |