Extract multiple records from Excel table

  • Thread starter Berne van de Laar
  • Start date
B

Berne van de Laar

I have an existing table with multiple entries. each has a status code "1" or
"2". ow do I create/extract into a new table only those records with a staus
code of "1".
 
A

Arvi Laanemets

Hi


Ardus Petus said:
Use Data>Filter>Automatic filter or Advanced filter
Click to expand...

Or an ODBC query (Data>Get External Data - and you have to define the source
table as a named range before)


Arvi Laanemets
 
Top