Excel Filter/Query

  • Thread starter Thread starter proben930
  • Start date Start date
P

proben930

Hi, I have a table of data laid out in a spreadsheet. I would some wa
of filtering out the rows that have a zero in one of the columns.
filter works, but I need something different.. because I am exportin
this data and it includes the filtered out rows as well. And it need
to be somewhat automated, if possible... maybe it flows into anothe
sheet. Any ideas? I put query in the title because it would retur
results similar to an access query.. basically create a new table on
new sheet. Thanks in advance
 
Why not link the Excel data as a table in Access and query it there?

File>Get external Data>Link tables

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You must log in or register to reply here.

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

Macro to copy value in field and insert it into filter 2
Link to filtered Data - AUTO 2
How to filter rows data based on background color of individual cells 1
pivot table value filter 1
Copy and pasting values of filtered rows 1
Excell Data Filter Fails to Integrate New Data-rows 2
Using Filter more than once 2
Filtering 2

Back
Top