View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_3_] Dick Kusleika[_3_] is offline
external usenet poster
 
Posts: 599
Default MS Query: Break data into separate sheets based on value?

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