Macro to transfer data

[gz3s36]

Looking for a macro to do the following: WHEN SHEET2! Column R cell matches SHEET1! Column C THEN populate SHEET2! Column Z cell from SHEET1! Column D

[dmcgov]

put the following code in a module. run it (as a test). does it do what you asked? if yes then i will write the routine that works on any row.

Please Login or Register  to view this content.

[gz3s36]

I couldn't get it to work.

[dmcgov]

let me upload a sample file. make sure to delete the contents of D1 on Sheet1 if it exists. so my code works for me.

[dmcgov]

so i misread the OP, the sub should be like this

Please Login or Register  to view this content.

replace your existing code with the above. sorry about the confusion

[gz3s36]

I guess I’m not wording what I’m looking for correctly. I need something that goes like this. If any cell in SHEET2! Column R matches any cell in SHEET1! Column C then I need the corresponding value in SHEET1! Column D to populate corresponding SHEET2! Column Z

I think I’m on the right track but my results will run the entire column instead of stopping on last row.
=VLOOKUP(R3,SHEET1!$C$2:$D$1000,2,0)

[gz3s36]

=IFERROR(VLOOKUP(R3,'PERSONAL CATALOG'!$C$2:$D$1000,2,0)," ") did the job. Youtube is a wonderful thing. Just like this forum.

[dmcgov]

thanks for posting your solution. please mark the thread as solved (even if you solved it).

thanks

[gz3s36]

Thought I did. Sorry.

[gz3s36]

I Did. I don’t know why it isn’t showing that.