Reading this again, you may want to use advanced filter... rather than
autofilter, as you will be able to filter it to a new location

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Nick Hodge" wrote in message
...
Berne

Highlight your headers and go to datafilterautofilter... and filter your
open and close column how you'd like

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Berne van de Laar" <Berne van de wrote in
message ...
I have a table with multiple records and many columns. Each record has a
status field with values either 1 or 2 (open or closed). I wish to create
a
new shorter table in the same worksheet with only the "open" records.