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.

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.

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.

On Sun, 2 Jul 2006 14:55:02 -0700, Berne van de Laar <Berne van de
wrote:

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.

Create a two cell criteria range, say A1:A2 with the field name for
the open column in A1 and '1' in A2.

Copy the field headings to where you want the shorter table to be.


Use: Data --Filter -- Advanced Filter from the menu, choose the
'Copy to another location' option and select the original table, and
the criteria range in the appropriate boxes, then "OK"

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________