K
Ken
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. "ABC"); insert a new worksheet; paste the copied
cells 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.
TIA.
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. "ABC"); insert a new worksheet; paste the copied
cells 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.
TIA.