Function to copy cell contents from sheet 1 to sheet 2

In sheet1 I am needing to copy the contents of A1 B1 and D1 to sheet2, ONLY if the value of Sheet1 G1 is "Yes"

How can I accomplish this?

Thanks in advance

Try this:

=IF(Sheet1!$G1="Yes",Sheet1!A1,"")

You can copy across to get B1 in the adjacent cell and D1 in two cells further over (or just change the C1 in the 3rd column to D1).

Hope this helps.

Pete