H
hef
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
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