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