-----Original Message-----

I have a file with almost 11K rows. I need to take those
rows and
create a new sheet for each group. Each group has a
unique number, but
there are an addition 7 columns that will need to be
moved as well...
There are a total of 833 groups.

For example (the '...' represent the remaining columns)

One sheet:

10 ABC ...
10 ABC ...
20 EFG ...
20 EFG ...
20 EFG ...
20 EFG ...
30 QRS ...
30 QRS ...
30 QRS ...

I would want three sheets:

Sheet A =
10 ABC ...
10 ABC ...

Sheet B =
20 EFG ...
20 EFG ...
20 EFG ...
20 EFG ...

Sheet C =
30 QRS ...
30 QRS ...
30 QRS ...

Thanks for any help!!!

Hillary


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.
Hillary;

This is pretty complex and may be a paying deal. You a
VBA macro to parse through the 11,000 lines and then put
the groups into their own page.

Thanks,

Greg