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 data>filter>autofilter... and filter your
open and close column how you'd like

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(E-Mail Removed)HIS


"Berne van de Laar" <Berne van de (E-Mail Removed)> wrote in
message news:E277E3CC-CAE2-4748-9675-(E-Mail Removed)...
>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
(E-Mail Removed)> 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
__________________________

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
(E-Mail Removed)HIS


"Nick Hodge" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Berne
>
> Highlight your headers and go to data>filter>autofilter... and filter your
> open and close column how you'd like
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> www.nickhodge.co.uk
> (E-Mail Removed)HIS
>
>
> "Berne van de Laar" <Berne van de (E-Mail Removed)> wrote in
> message news:E277E3CC-CAE2-4748-9675-(E-Mail Removed)...
>>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.
>
>