First time poster here. Current issue is beyond my VBA abilities at this stage, please advise! 🙂
Basically I have worksheet1 and worksheet2. Worksheet 1 needs to be updated with information from worksheet2 with the new information. Only some items in worksheets database will need the update.
So, Column (D) has the identifier (EG:0677) and Column (I) has the information that needs to be updated.
Script needs to search column (D) on worksheet1 to match worksheet 2s Column (D) then replace information on the same row in column (I) on worksheet 1 with worksheet 2s information.