Database query from same worksheet

H

Hall

I know how to create a database query from another worksheet.

But can the query be from the SAME worksheet? How is that done?
 
H

Hall

But that's a filter not a query. By query, I'm looking at doing an SQL as
in querying from an external database. I can do that for external
worksheets. I'm asking if I can query from the same worksheet. I'm not
sure you understood my question.

I hope the response you gave won't keep others from offering an answer.
 
N

Nick Hodge

I'm obviously not understanding your question. If you want to query data
from the *same* worksheet, by definition, the data is already on the
*worksheet*. If it's already there then you can effectively 'query' the
data by using autofilter.

Do you mean from the same *workbook*?

If the answer to the above is yes, then no, you can build a pivot table from
the same source, but not a query via Data>Import External Data. If you try
this, it will get to the final screen, but you will get a syntax error as it
cannot query from itself

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top