Create new excel table with filtered records from another table

  • Thread starter Berne van de Laar
  • Start date
B

Berne van de Laar

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.
 
R

Richard Buttrey

On Sun, 2 Jul 2006 14:55:02 -0700, Berne van de Laar <Berne van de
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.
Click to expand...

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
__________________________
 
Top