Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
Linking feature changed in Excel? | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions |