View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Berne van de Laar Berne van de Laar is offline
external usenet poster
 
Posts: 1
Default Create new excel table with filtered records from another table

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.