Excel worksheet linking
 

Hi,

I'm trying to transfer specific datas from Worksheet 1 to Worksheet 2.

For example:
Worksheet 1
A B C D
1 George 80% 85% Grade B
2 Anna 100% 98% Grade A
3 Lynn 53% 60% FAIL

How do I have Excel pick out only those who have FAIL in cell D and transfer
the whole line of data (Transfering data in Column A to D) to worksheet 2?

I'm not good with Excel so please include a sample formula....Thank you!!