converting single column of data into a series of mini tables

[Jim Cavedo]

I have two sheets
Sheet two has lots of columns, 200 rows, one of the columns has a unique identifier to a customer. I want to convert that column of data into a series of mini tables on another sheet with similar unique identifiers grouped together (the groups will vary in size form 9 to 30 total like customers)....

Sheet 2
C1
C2
C3
...
T1
T2
T3
...
G1
G2
G3

I want on sheet one
C1 C2 C3
C4 ...

T1 T2 T3
T4....

I will also apply some conditional formatting

Is there anyway to this this?

 

[Hui]

Have a read of:
http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/

You could also use an Advanced Filter
http://chandoo.org/wp/2011/10/10/how-to-use-advanced-filters/