| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting a text file into individual worksheets
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| splitting data across worksheets | Excel Discussion (Misc queries) | |||
| Importing XML files into individual worksheets | Excel Discussion (Misc queries) | |||
| Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
| password protect individual worksheets | Excel Discussion (Misc queries) | |||
| Copying many tabs from one file to an individual file for each tab | Excel Discussion (Misc queries) | |||
![Sam Chambers[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
