Extract multiple records from Excel table
 

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

Extract multiple records from Excel table
 

Use DataFilterAutomatic filter or Advanced filter

HTH
--
AP

"Berne van de Laar" a écrit dans
le message de news: ...
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".

Extract multiple records from Excel table
 

Hi


"Ardus Petus" wrote in message
...
Use DataFilterAutomatic filter or Advanced filter

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


Arvi Laanemets