Excel Filter/Query

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
 
N

Nick Hodge

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
[email protected]
 
Top