elevate_yourself
New Member
- Joined
- Oct 9, 2014
- Messages
- 15
Hello,
I am very new to VBA and am looking to find a way to search through an array using a range of cells and then make updates to the cells if there is a match. As an example:
<tbody>
</tbody>
What I would like to be able to do is search the "Array of Names" column (which I would like to make as an array) and for any names that match the "Change Names" column, and update the values in the Number columns to 0 for all. So in the end it would look like:
<tbody>
</tbody>
I hope this is clear enough - if more clarification is needed please let me know
I am very new to VBA and am looking to find a way to search through an array using a range of cells and then make updates to the cells if there is a match. As an example:
A | B | C | D | E | |
1 | Change Names | Array of Names | Number 1 | Number 2 | Number 3 |
2 | Timmy | John | 5 | 6 | 7 |
3 | John | Billy | 5 | 6 | 7 |
4 | Mark | Mike | 5 | 6 | 7 |
5 | Mark | 5 | 6 | 7 | |
6 | Timmy | 5 | 6 | 7 |
<tbody>
</tbody>
What I would like to be able to do is search the "Array of Names" column (which I would like to make as an array) and for any names that match the "Change Names" column, and update the values in the Number columns to 0 for all. So in the end it would look like:
A | B | C | D | E | |
1 | Change Names | Array of Names | Number 1 | Number 2 | Number 3 |
2 | Timmy | John | 0 | 0 | 0 |
3 | John | Billy | 5 | 6 | 7 |
4 | Mark | Mike | 5 | 6 | 7 |
5 | Mark | 0 | 0 | 0 | |
6 | Timmy | 0 | 0 | 0 |
<tbody>
</tbody>
I hope this is clear enough - if more clarification is needed please let me know