Hi,

I'm in great need of a macro that will take an existing single 'datasheet' of records, read through all the records, and copy each individual record to a new tab (leaving the original datasheet intact).

The data is organized as follows:
* Each record is 8 columns wide, but varies in number of rows.
* Each record is 'delimited' by the word "Company" in a single cell, followed by another cell with a number value.
* The datasheet contains 200-300 records; So we'd like to have a macro that creates 200-300 sheets, one for each Company record, with the tab name being Company + Number.
* Within the data sheet, the first five rows are not records; They are dedicated to header info (report title, date, etc.)

Any help with providing a macro or code stub(s) would be greatly appreciated...

Many Thanks,
- KJHScmidt

P.S. The datasheet originally begins life as a text file (tab-delimited fields). The data structure above is the result of importing into excel using default options.