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?