Greetings,
I would appreciate your help with VBA Code for the following requirement
- This is all within the same worksheet
- If value in cell D2 = 1, then Copy value from Cell B2 and Paste into Cell C2
- If value in cell D2 = 0; skip row and do not update cells C2
- Go through the entire range until all rows are checked and cells in C are updates as needed
- Need to exclude header row 1 and subtotal row at the end of the range
I would appreciate your help with VBA Code for the following requirement
- This is all within the same worksheet
- If value in cell D2 = 1, then Copy value from Cell B2 and Paste into Cell C2
- If value in cell D2 = 0; skip row and do not update cells C2
- Go through the entire range until all rows are checked and cells in C are updates as needed
- Need to exclude header row 1 and subtotal row at the end of the range
Expense (Col A) | OriginalTax (Col B) | NewTax (Col C) | Variance (Col D) |
Exp1 | 5.74 | 5.74 | 0 |
Exp2 | 4.56 | 2.1 | 1 |
Exp3 | 12.34 | 12.43 | 1 |
Exp4 | 10 | 9 | 1 |
Exp5 | 9 | 9 | 0 |
Exp6 | 8 | 8 | 0 |
Exp7 | 7 | 7 | 0 |
Exp8 | 4 | 3 | 1 |
Exp9 | 3 | 2 | 1 |
Exp10 | 5 | 5 | 0 |
SUBTOTAL | 68.64 | 63.27 |