Posted 24 July 2009 - 12:53 PM
Is this a one time copy? If so, you can turn on Excel's data filter function on the first sheet, filter the data, and copy the results to a new sheet?
1. In Excel, select cell A1 of your data sheet and then: Data > Filter > AutoFilter.
2. Click Column E's down-arrow and select the criteria to show.
3. Select the filtered rows and copy / paste them elsewhere.
I'm not sure how to return an entire row with a formula, but you can return a part with a VLOOKUP function...
-A1 is your search criteria (add $ before A and 1 to make it static)
-The second part is where you're looking (always searching the first column selected)
-2 is what column to return (if you started in A it returns result from B )
-FALSE stops Excel from giving 'next best' answers.