Excel help

doc ron

Dual Best & Fairest
Joined
8 Feb 2013
Messages
3,399
Likes
521
AFL Club
Hawthorn
#1
To all the Excel Gurus out there, and i Know there are a few of you. I have a spreadsheet containing about 25000 rows of data across about 10 Columns, I would like a quick and easy way to separate those rows into smaller sheets based on the info in one of the columns. There are about 60 different id's in that particular column, so like all the rows for each of those 60 id's separated into 60 different sheets. It is Horse Racing info and I want to separate it into different sheets based on individual Tracks.
 

doc ron

Dual Best & Fairest
Joined
8 Feb 2013
Messages
3,399
Likes
521
AFL Club
Hawthorn
#3
No, a bit of a novice at this. But actually came across something calles Kutos for excel which has a split data feature in it, which seemed to do the trick. Only issue is it just names all the new sheets 1 2 3 etc. instead of the individual track names. Have you used this before Thanh?
 

Beg2Differ

Rising Star Winner
Joined
22 Oct 2014
Messages
371
Likes
141
AFL Club
North Melb.
#5
To all the Excel Gurus out there, and i Know there are a few of you. I have a spreadsheet containing about 25000 rows of data across about 10 Columns, I would like a quick and easy way to separate those rows into smaller sheets based on the info in one of the columns. There are about 60 different id's in that particular column, so like all the rows for each of those 60 id's separated into 60 different sheets. It is Horse Racing info and I want to separate it into different sheets based on individual Tracks.
Should be reasonably straight forward. Email it through and I will take a look.

Is it something you want to be repeatable or is it just a once off?
 
Top