Split & Consolidate Worksheets

[mooner_sg]

Hi

I have a listing of few thousand rows and 20 columns. Say
column A contains Team A, B, C....etc, how do I split the
listing into multiple worksheets with the same heading by
Teams and if possible name each worksheet after the team
name, i.e. "Team A", "Team B"...etc.

On the other hand, how do I consolidate or merge multiple
worksheets into a single worksheet and the first column
be the worksheet names?

Appreciate if anybody can help me.

Regards,
HF

 

[Frank Kabel]

Hi
for splitting you may take a look at 'Data - Filter - Advanced Filter'

 

[rushnrush]

Hi Frank,

Thanks for the reply.
Advanced Filter doesn't help as it can only split within
the same worksheet. What I need is to auto splitting the
data into worksheets by Team.
For example, if I have 20 columns of data where first
column is Team name, and at the same time, I have 20
teams where each team has 100 rows of data, is there a
program can help me to split the data into 20 worksheets
named after each team name and containing data of 100
rows x 20 column in each worksheet?

Best regards,
HF

 

[Ron de Bruin]

Try this
http://www.rondebruin.nl/copy5.htm

 

[James]

Hey Ron,
Thanks for posting this reply! I've almost figured it out. However, I can't
seem to get the sheets to autoname correctly. any ideas?
ALSO, how would I do this to create new workBOOKS instead of sheets? Is that
possible?

 

[Ron de Bruin]

Hi James

Post the code you are using now and i take a look at it

 

[James]

Ron,
I have already figured out my problem, the column I was using had an "*" in
it so it forced me too rename everytime.

seriously, thanks for following up, you guys are awesome!

James