I have found this newsgroup to be exceedingly helpful with many not-so
easy questions. It is almost as if readers race to see who can be the
first to answer my questions. I think you too will get a speedy
response if you ask appropriate question(s).

I don't mean to be critical, but I speculate that you have not received
a response to your posting because you are not really asking a question.
The "answer" you are seeking is a not really an "answer," but a
solution to your problem. If you want someone to put together a
turn-key solution to your problem, I suggest you hire one of the many
Excel experts that monitor this newsgroup.

This newsgroup will undoubtedly help you develop a solution to your
problem if you partition it into smaller problems that can be asked as
questions. I suggest you block out your problem in a flow chart (or
equivalent), define the functional blocks, and then seek help on how to
implement those functions.

- - - - - - - -

Ken wrote:
(We put this out to the "Worksheet Functions" group
yesterday and have had no response. Either we explained it
too poorly to get a response; it is too much programming
assistance to ask from this source; or the folks in that
group did not have the macro expertise to respond. So, we
are trying for assistance here.)

Using Excel 2000.

We have 2,000 - 3,000 rows of imported text data.

Sample layout is:
A B C D

1 ABC
2 xx xx $45
3 xx xx $34
4 xx $4
5 FGE
6 xx xx $55
7 xx $67
.....

Rows are sorted based on the entries in Column A if there
is a blank entry in column B. There are about ten
groupings of sorted items - ten groups
labeled "ABC", "FGE", etc.
Each new group starts with a blank entry in column B.
We are trying to get a macro that will loop through the
3,000 rows; copy the range of rows from one group
(e.g. for group "ABC" we would copy rows one through
four); insert a new worksheet; paste the copied
rows to the new worksheet; rename the new worksheet with
the label from column A (e.g. "ABC"); insert a new row 1
into the new worksheet with A1="Name", A2="ID", A3="Amt";
and then loop back.
Then the macro will have to stop when it realizes it is at
the end of the data. (Alternatively, the macro could start
at the bottom and work back to the top.)
TIA.