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?