All, I need your help in writing a macro,
My column definitions are,
Column - B - > Identifier
Column - C - > Available
Column - J - > Spent
Column - K - > Reference
I have the following cell arrangement
B5=A
C5=10000
B6=B
C6=8000
so on...
This is constant.
If I enter the following values at,
J8=2000
K8=A
Then my macro need to check column - B to identify where we have the value "A" and it has to update the cell C5 as C5 - J8.
Could someone please help to write a excel macro on this.
Note: In B6, B7, B8 cells, I have different alphabets with the corresponding amount entered on it.
My column definitions are,
Column - B - > Identifier
Column - C - > Available
Column - J - > Spent
Column - K - > Reference
I have the following cell arrangement
B5=A
C5=10000
B6=B
C6=8000
so on...
This is constant.
If I enter the following values at,
J8=2000
K8=A
Then my macro need to check column - B to identify where we have the value "A" and it has to update the cell C5 as C5 - J8.
Could someone please help to write a excel macro on this.
Note: In B6, B7, B8 cells, I have different alphabets with the corresponding amount entered on it.
