Copying from Sheet1 to Sheet2

[fishax]

Hello,
I need some guidance to achieve the following. I need to copy value from Sheet1 to Sheet2, if an equal condition is met for one of the cells on both sheets. This illustrates what I need.

Sheet 1
Cell A1 : X
Cell A2 : Y
Cell A3 : Z

Sheet 2
Cell A1 : X
Cell A2 : D

What I need is for occurance of X (Cell A1) on Sheet 1, I need to copy value of Cell A2 (Y) to Sheet2 i.e. final output would be

Sheet 1 (unchanged)
Cell A1 : X
Cell A2 : Y
Cell A3 : Z

Sheet 2
Cell A1: X
Cell A2: Y

 

[PHV]

What have you tried sofar and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fishax]

I managed to get it working via vlookup, but I had an Email firing on WorkSheet Change Event, which now does not work since I am using Calculation (vlookup) to populate the Cells on Sheet 2 vs manual. Will have to think of something else to fire the email when condition is met on Sheet2.