Hi all,

Apologies if this post is in wrong place but I'm new and just started to move around forum.

I've come across a problem, and I will try to explain what I'm after:

I've got a workbook with 2 worksheets, the first one is blank, the second contains the following info: COLUMN A - product codes, B - production dates, C - best before, D - product location,

In worksheet 1 I would like to paste in info in exact format as worksheet2 (COLUMN A - product codes, B - production dates, C - best before, D - product location,)

I'm after a macro or a function that compares LOCATION in both worksheets and if - for example D3 in worksheet 1 is the same as D3 in worksheet 2 than whole row 3 in worksheet 2 will be replaced with row 3 from worksheet 1.

Is this doable ?? could anybody help me with this please as I've scanned different websites looking for an answer with no luck (example workbook attached)

Many Thanks
Book1.xlsx