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.
--
David Biddulph

"scootr" wrote in message
...
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?