I have a file with almost 11K rows. I need to take those rows an
create a new sheet for each group. Each group has a unique number, bu
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!!!

Hillar

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