OK, that's good


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sam Chambers" wrote in message ...
Never mind...I figured out where to put the code, and the "Create separate
sheet for each horizontal PageBreak" code worked beautifully!

Thanks very much, Ron! You just saved me a ton of time!

Sam.

"Sam Chambers" wrote:

Ron:

I've been looking through some of the other examples on your site, and I
think your "Create separate sheet for each horizontal PageBreak" code would
be easier. I still have no idea how to use it, but it sure looks like it
would work!

Sam.

"Ron de Bruin" wrote:

Hi Sam

After you open the file in excel you can use the code from this page
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Sam Chambers" wrote in message
...
I have a large (8,000 lines) text file that I need to import into Excel. The
thing is that I need to get the file into separate worksheets, based on
department number. The departments change about every 50 lines or so (it's
variable).

I've racked my brain and can't think of a way to do this, other than doing
it manually. Any ideas?