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!!
|