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?