Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combining data from two separate sheets | New Users to Excel | |||
Pivot Data and Filter on separate sheets | Excel Discussion (Misc queries) | |||
External data connection needs separate login for each query | Excel Discussion (Misc queries) | |||
QUERY data range to populate separate worksheet? | Excel Worksheet Functions | |||
Splitting Data into separate sheets | Excel Discussion (Misc queries) |