loop through file creating seperate files depending on name in a column

Hi

i have file with approx 12,000 rows with columns A:I populated with data

in column G is a name

example rows 7:100 are rows for Tom Smith,

i need a macro that will loop through all 12,000, then create seperate excel files for each name

so first example would be one file with just tom smiths rows in it,
second file be the next person

is this atall possible?
thanks

See if this works for you.

If not, need to see your workbook.

Please Login or Register  to view this content.

hi thanks for the reply!

on the attached, ive removed a lot of data so its just 200 lines, with 3 people - the end result being 3 seperate files by the 3 names in the file.

the actual main file will always be 11,0000 - 12,0000 rows with around 50 people

thanks

Please Login or Register  to view this content.

hi

i get an evalute error at this point

Please Login or Register  to view this content.

thank you

Working for me...

hi works perfectly on 200 rows, but my master file is 12,000 rows and it seems to spit up an error on there? thanks

If you still get error then try this one.

Please Login or Register  to view this content.

perfect thank you

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

I will sneak this one in for posterity..

Used a couple of methods straight from snb's site.. as you can probably see..

Please Login or Register  to view this content.