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 past it in column J.
here is an example basically i want to find and fill Sheet "Update" with data from sheet "Updating"
Thank you for your time and answers 🙂
April 10, 2025, update for Office 2016 (KB5002623)
This update fixes the known issue in KB 5002700 that causes Microsoft Word, Microsoft Excel, and Microsoft Outlook to stop responding.
This update is available for manual download and installation from the Microsoft Download Center.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
3 Replies
Sort By
- NikolinoDEGold Contributor
- MicrosoftNewbie121Brass 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 - MicrosoftNewbie121Brass ContributorHello NikolinoDE that is working perfectly, can you please teach me how can i apply this example to update Owner 1 Column please ?