Find ID in another sheet and copy details over

[Sazza]

Hi Guys,

I have a script where i'm trying to :

(1) lookup column 2 in the "Acct Awaiting 2 week review" worksheet against column 2 in the "MIV Case Details" worksheet and

(2) when it finds a match copy the details from column N in "Acct Awaiting 2 week review" into column N in the "MIV Case Details"

I have the following and according to my message box the data matches but nothing copies ?
Can you help me please ?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

What are the values of changing_data and to_be_changed_data? Try:

Please Login or Register  to view this content.

[Sazza]

Hi John,

the last row of data in each sheet -- I've tried calling she sheets names but no joy.

you helped me previous and it worked perfectly but when I went to replicate the exact same script across different sheets it wouldn't work.

[JOHN H. DAVIS]

Are you referring too this thread?

[Sazza]

this one ... https://www.excelforum.com/excel-pro...ml#post4728393

[JOHN H. DAVIS]

Repost and let me know which sheets you want it too work on.

[Sazza]

I don't know what you mean by repost ? repost the original post - how do I do that please ?

I need it to do exactly the same as what you gave me just copying from other tabs back to the main tab .. I created a sub on each tab - linked to a button but cannot get it to work