Extract multiple records from Excel table

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create new excel table with filtered records from another table 3
How to export table from outlook into ms access table? 0
Counting multiple memberships 1
Is there a way to extract multiple values from an INDEX result ? 3
Absolute References and worksheets 0
select multiple records in database given conditions 1
Pivot Table or lookup? 8
Macros to extract data frommultiple workbooks to a master workbook 0

Top