MS Query: Break data into separate sheets based on value?
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
|