Forum Discussion
MicrosoftNewbie121
Feb 02, 2024Brass Contributor
VBA Find and update values if the ID Match
Hello, i would like an example of VBA code please to search an ID from a Sheet2 (in ID list column B) if it matche the ID list column B in Sheet1 then (if found) copy value of column F Sheet2 and pas...
- Feb 02, 2024
NikolinoDE
Feb 02, 2024Gold Contributor
- MicrosoftNewbie121Feb 02, 2024Brass ContributorSorry for disturbing just found how to do this 🙂 thank you so much
Editing this line change everything
wsUpdated.Cells(matchingID + 1, "F").Value = updatingIDCell.Offset(0, 6).Value - MicrosoftNewbie121Feb 02, 2024Brass ContributorHello NikolinoDE that is working perfectly, can you please teach me how can i apply this example to update Owner 1 Column please ?