How do I split data into multiple tabs for excel 2003? 1

[okiiyama]

I have data in Sheet1, about 4500 rows, and I need to split this data into new sheets based on the data in the 1st column. It would be a bonus to have the tab name be what is in the first column. Splitting the data into multiple tabs will result in about 90 new tabs.

Any VBA script that I can copy and run, or is it possible to do this with a PivotTable? I'm not experienced with either.


Thanks.

 

[Andrzejek]

You may want to read this tread.

Have fun.

---- Andy

 

[okiiyama]

Thanks for the reply, I appreciate it.

However, I found a program with a free trial that did what I needed to do in a snap:

http://www.extendoffice.com/product/kutools-for-excel.html

^^I'm not sure if this is promoting or not, the link to the program, was the answer to my solution.