K
Ken
(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.
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.