IF formula between tabs

[scootr]

If cell D2 in tab 1 has the letter "A" in it then I want the entire row of
cells (A2 - O2) to be copied into tab 2.

Is there a formula that can accomplish this?

 

[David Biddulph]

In Sheet2!A2 use the formula
=IF(Sheet1!$D2="A",Sheet1!A2,"")
or perhaps (to cope with blanks)
=IF(AND(Sheet1!$D2="A",Sheet1!A2<>""),Sheet1!A2,"")
and copy across.

 

[scootr]

I tried both forumlas. I copied them across and down. But how do I get rid of
the blank cells?