Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Data
When importing a large file into Excel that flows over the limit of one
worksheet, is there a way to have it automatically flow to the next sheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Data
We will need a macro to import line by line and keep counting. Once line
number exceeds a preset limit, switch to next sheet please. Cheers "Sash" wrote in message ... When importing a large file into Excel that flows over the limit of one worksheet, is there a way to have it automatically flow to the next sheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Data
Can you point me in the direction of an example of such?
"PY & Associates" wrote: We will need a macro to import line by line and keep counting. Once line number exceeds a preset limit, switch to next sheet please. Cheers "Sash" wrote in message ... When importing a large file into Excel that flows over the limit of one worksheet, is there a way to have it automatically flow to the next sheet? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Data
This is one of THE most faq.
Google with key words "line input" will give you tons of it please. "Sash" wrote in message ... Can you point me in the direction of an example of such? "PY & Associates" wrote: We will need a macro to import line by line and keep counting. Once line number exceeds a preset limit, switch to next sheet please. Cheers "Sash" wrote in message ... When importing a large file into Excel that flows over the limit of one worksheet, is there a way to have it automatically flow to the next sheet? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Data
Microsoft has a macro solution that may help:
http://support.microsoft.com/default...;EN-US;q120596 XL: Importing Text Files Larger Than 16384 Rows (written for xl95, but has a note to change stuff for xl97+) I'd just use my favorite text editor and split the data into smaller pieces--and then import each piece to a new worksheet. Sash wrote: When importing a large file into Excel that flows over the limit of one worksheet, is there a way to have it automatically flow to the next sheet? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |