Hi,
I'm quite new to VBA and I'm struggling to find a solution to this. I'm trying to delete the value from Column 2 and Column 3 if it contains the value in its corresponding row in Column 1. i.e. for the first row delete 94000 from Column 3, then loop to the next column and delete 50000 from the Column 2. The searched for text needs to be the value in Column 1 and delete the value in Column 2 / 3 if it matches that of Column 1.
Any help would be much appreciated!
<tbody>
</tbody>
I'm quite new to VBA and I'm struggling to find a solution to this. I'm trying to delete the value from Column 2 and Column 3 if it contains the value in its corresponding row in Column 1. i.e. for the first row delete 94000 from Column 3, then loop to the next column and delete 50000 from the Column 2. The searched for text needs to be the value in Column 1 and delete the value in Column 2 / 3 if it matches that of Column 1.
Any help would be much appreciated!
Column 1 | Column 2 | Column 3 |
94000 | SAN RAMON | CA 94000 |
50000 | CA, 50000 | |
0400 | NH | 03780-0400 |
60000 | Batavia, IL | 60000 |
90000 | CA | 90000 |
<tbody>
</tbody>