Populate worksheet by query

I have a very large worksheet that is basically a dump from another database that is e-mailed to me. I would like to parse this sheet into several other sheets by running a query or similar. Is there a way to enter an sql query and have it generate a new sheet containing the results?

I am using Excel 2003 SP2

Thanks,
Carl

Originally Posted by isofuncurves

I have a very large worksheet that is basically a dump from another database that is e-mailed to me. I would like to parse this sheet into several other sheets by running a query or similar. Is there a way to enter an sql query and have it generate a new sheet containing the results?

I am using Excel 2003 SP2

Thanks,
Carl

not as such, have you examined the 'Filter' options, you can filter a Sheet and then copy-and-paste the displayed rows.

You may need to include a helper column to emulate the query, depending on what you need to find.

hth
---