Why not link the Excel data as a table in Access and query it there?

FileGet external DataLink tables

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"proben930" wrote in message
news

Hi, I have a table of data laid out in a spreadsheet. I would some way
of filtering out the rows that have a zero in one of the columns. A
filter works, but I need something different.. because I am exporting
this data and it includes the filtered out rows as well. And it needs
to be somewhat automated, if possible... maybe it flows into another
sheet. Any ideas? I put query in the title because it would return
results similar to an access query.. basically create a new table on a
new sheet. Thanks in advance!


--
proben930
------------------------------------------------------------------------
proben930's Profile:
http://www.excelforum.com/member.php...o&userid=14590
View this thread: http://www.excelforum.com/showthread...hreadid=262175