Hi,
I want to:
1. Compare between 2 cells in first row of a big table.
2. If it matches (red color is the match words) copy the content of 'CustomerB to CustomerA' row by row.
3. Code inside the curly bracket {} , i'm not sure how to do this.
<tbody>
</tbody>
thanks in advance.
I want to:
1. Compare between 2 cells in first row of a big table.
2. If it matches (red color is the match words) copy the content of 'CustomerB to CustomerA' row by row.
3. Code inside the curly bracket {} , i'm not sure how to do this.
<tbody> </tbody> |
<tbody> </tbody> | CustomerB Dose Step 2 Target | CustomerB Dose Step 1 Target | ||
2 | 4 | 6 | 8 | ||
3 | 5 | 7 | 9 |
<tbody>
</tbody>
Code:
For i = 17 To 298 Step 1 'range of CustomerA
For j = 300 To 385 Step 1 'range of CustomerB
if { cells(1 , i) = cells(1 , j) } Then '(I am not comparing two cells entirely, I'm comparing the last past of the value. not sure how to do this)
for x = 2 To LastColumn
cells (x , i) = cells (x , j)
next x
next j
next i
thanks in advance.