Thread: if then copy cell to different worksheet

I have been racking my brain on this:

If I type "Y" in cell A2 on sheet1 then I want excel copy cell B2 on sheet1 onto D4 on sheet2.

Basicially I want to choose y and excel will copy the text beside the y to another page. But I have a few options that can be y, but only one can be at any time.

Do you like Fruit
Y Apple
N Grapes
N Oranges

I've done it before, cannot remeber how!

Thanks in advance

Almost, but not quite. It is only pulling the "Y" from cell A2. I might have a Y in A2, A3, or A4, and I need to pull the text in the left of those cells to the a different sheet if a "Y" is present.

Your doing better than I was.... but still not working.

Works in A2 only.

There is different text beside A3 amd A4, and when I put a "Y" in A3 or A4 or sheet1 it does not copy the text beside A3 or A4 onto D2 of sheet2

Works! Thanks a mil!