Find/Compare and Copy Certain Cells

[ScabbyDog]

I have the below code which deletes the row in SheetM if a match is found. But I want to alter it so that if it finds a match in sheetLW then I want it to copy what is in col F,G,H in sheetLW and paste into sheetM col H,I and J.

Please Login or Register  to view this content.

[AB33]

Untested code

Please Login or Register  to view this content.

[ScabbyDog]

What If I want what is in col D in LW to be put into col C on sheetM as well as the above?

[ScabbyDog]

Your code pastes the values to the bottom of SHeetM and not in the same row as the match was found.

[AB33]

Sorry,
My offset was wrong, Should have been

Please Login or Register  to view this content.

Second request

Please Login or Register  to view this content.

[AB33]

Amended

Please Login or Register  to view this content.

[ScabbyDog]

I'll test that now. Many thanks!

[ScabbyDog]

Works better. Almost there. Except with ( ms.Cells(c4.Row, 8).Resize(, 3) = c3.Offset(, 3).Resize(, 3) ) instead of copying and pasting whats in SheetLW into SheetM all it does is clear the contents of the cells in SheetM.

[AB33]

Hmmm! Column H and C of sheet LW should be blank

Try this one then

Please Login or Register  to view this content.

[ScabbyDog]

Not quite what I need. Very close. Perhaps I know why, can you please adjust it. I need M, N, O, P, Q and R in SheetLW to be put into SheetM G, H, I, J, K, L.

[AB33]

Please Login or Register  to view this content.