I wish to filter results from one sheet onto a second sheet.
I have a data table containing 13 columns, but only columns 1,2 & 4 are
needed in the filtered results.
Column 1 contains either "In" or "Out". Col.2 a name, Col.4 a location.

I wish to place on sheet 2 all records shown as "Out".

I've tried the VLOOKUP but guess I'm not getting the right parameters.

Help appreciated.
Thanks.

PS - I'm working with Excel 2007, but the workbook has to be compatible with
2003.
--
Wercs