Hi All,
Before I state my problem I just want to say that I have learned alot from this forum and thanks in advance to whoever answers!
So I've looked around the forums and I've not really found a solution which works exactly.
Say my sheet is set up as below
A B C
1 AAA 12 0
2 BBB 14 0
3 CCC 0 5
4 DDD 2 4
Column C has formulas the whole way down that either returns zero or a value. In the instances where there are values, I want the code to copy the value from column C and paste it into the respective row in column B. If the Value in column C is 0, then I want the value is column B to remain as is.
I'm not sure how to approach this problem, some sort of loops which goes through and checks would probably be the best way but I'm not sure how to proceed. Any input would be much appreciated!
Before I state my problem I just want to say that I have learned alot from this forum and thanks in advance to whoever answers!
So I've looked around the forums and I've not really found a solution which works exactly.
Say my sheet is set up as below
A B C
1 AAA 12 0
2 BBB 14 0
3 CCC 0 5
4 DDD 2 4
Column C has formulas the whole way down that either returns zero or a value. In the instances where there are values, I want the code to copy the value from column C and paste it into the respective row in column B. If the Value in column C is 0, then I want the value is column B to remain as is.
I'm not sure how to approach this problem, some sort of loops which goes through and checks would probably be the best way but I'm not sure how to proceed. Any input would be much appreciated!