keresztesi
Board Regular
- Joined
- Aug 14, 2017
- Messages
- 64
Hi,
I'd like to have a vba code for the following:
1. the code should search for numeric value in column "V" (there is either only one cell with number or all cells are blank). If there's a nr. then:
2. in the row where the number is (for example it's the 20th) it searches again for a number in range W20:AA20
3. then it searches again for numeric values in range W2:AA1000 and if it finds a value that is greater then the one found in range W20:AA20 then it adds the value from column "V"
4. finally it deletes the numeric value from column "V"
For example:
BEFORE:
<tbody>
</tbody>
AFTER:
<tbody>
</tbody>
Thx in advance!
Zoli
I'd like to have a vba code for the following:
1. the code should search for numeric value in column "V" (there is either only one cell with number or all cells are blank). If there's a nr. then:
2. in the row where the number is (for example it's the 20th) it searches again for a number in range W20:AA20
3. then it searches again for numeric values in range W2:AA1000 and if it finds a value that is greater then the one found in range W20:AA20 then it adds the value from column "V"
4. finally it deletes the numeric value from column "V"
For example:
BEFORE:
V | W | X | Y | Z | AA | |
1 | 1 | 10 | ||||
2 | 2 | 5 | ||||
3 | 6 | |||||
4 | 4 | |||||
5 | ||||||
6 | 3 | |||||
7 | ||||||
8 | 9 | |||||
9 | 8 | |||||
10 | 7 |
<tbody>
</tbody>
AFTER:
V | W | X | Y | Z | AA | |
1 | 1 | 15 | ||||
2 | 2 | 10 | ||||
3 | 11 | |||||
4 | 5 | 9 | ||||
5 | ||||||
6 | 3 | |||||
7 | ||||||
8 | 14 | |||||
9 | 13 | |||||
10 | 12 |
<tbody>
</tbody>
Thx in advance!
Zoli