JB
I don't think you can do that and have all the data still be part of the
same query. However, you could have multiple queries, one per sheet. If
you have a field that can have one of three values, for example, you could
create three worksheets and put a query on each sheet with the appropriate
criteria so as to limit the records for that sheet.
--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.
"JB" wrote in message
...
Hello,
I have a spreadsheet that is populated from an external
source with a database query (ODBC). My problem is that
the query returns too many rows to fit in a single Excel
sheet.
Is there a programmatic way to split up the data into
separate worksheets, based on the value of a particular
column?
I am familiar with macro programming, although I do not
have a lot of experience. If someone could get me started
in the right direction, I would appreciate it.
TIA,
JB