Hello! I have a spreadsheet that others will use to correct data entries for a unique identifier (i.e., there is only one instance of that text string on a given sheet.) In short, the main spreadsheet imports data from different spreadsheets, and any incorrect unique identifiers must be corrected in the main spreadsheet before other operations can be performed.
I am looking for a VBA-based way to find the Unique Identifier entry from column B, Sheet 1 in Column B, Sheet 8, and replace it with the value in the same row on Sheet 1, Column 6. (Sheet 8 contains sensitive data and is hidden from users). A sample layout of Sheet 1 is below. In my example, ABC123 would be replaced in Sheet 8 Column B with ADB123 (and that would happen with every other unique identifier on Sheet 1, CDE456 being replace in Sheet 8 by CDF457 and so on). As stated above, there is never more than one instance of the unique identifier on either Sheet 1 or Sheet 8. I have used my Google-fu on various posted VBA solutions, but nothing has been close enough to allow my novice-level coding skills to parse a solution. Can someone point me in the right direction, or even suggest a combination of VBA functions to make this happen? Thanks!
<tbody>
</tbody>
I am looking for a VBA-based way to find the Unique Identifier entry from column B, Sheet 1 in Column B, Sheet 8, and replace it with the value in the same row on Sheet 1, Column 6. (Sheet 8 contains sensitive data and is hidden from users). A sample layout of Sheet 1 is below. In my example, ABC123 would be replaced in Sheet 8 Column B with ADB123 (and that would happen with every other unique identifier on Sheet 1, CDE456 being replace in Sheet 8 by CDF457 and so on). As stated above, there is never more than one instance of the unique identifier on either Sheet 1 or Sheet 8. I have used my Google-fu on various posted VBA solutions, but nothing has been close enough to allow my novice-level coding skills to parse a solution. Can someone point me in the right direction, or even suggest a combination of VBA functions to make this happen? Thanks!
Unique Identifier | Name | Email | mismatch? | Enter the corrected Unique Identifier below | |
ABC123 | abc | abc@abc.com | X | ADB123 | |
CDE456 | abcd | abc@abc.com | X | CDF457 | |
FGH678 | abcde | abc@abc.com | X | FGH677 | |
IJK9111 | abcded | abc@abc.com | X | IJL1111 |
<tbody>
</tbody>