Split a master file into separate files based on a key column

Hello,

I require a looping macro that will work through this data and create a separate file for each location listed in column C.
I will place the master file in the same folder every time and require the splitter to create a file for each unique location with each split file taking the name of its location.
In the enclosed example there are four locations so four output files required.

In reality I have a file of over 2,000 rows with about 40 different locations, but hopefully the example file is enough to explain my requirement.

Thanks for any help you can give.

Apologies, I may not have explained myself very well. On each of the four finished location files I require the full data for each location.
So the finished files for Birmingham and Glasgow for example would look like the attached, and then London and Manchester would be the same with their own data.

Thank you Robert, your code works great.

Originally Posted by picton2000

Apologies, I may not have explained myself very well. On each of the four finished location files I require the full data for each location.
So the finished files for Birmingham and Glasgow for example would look like the attached, and then London and Manchester would be the same with their own data.

Just try again my demonstration as it well works on my side !
Same result as yours as it just reproduces what even a beginner can yet do manually just with Excel basics …

Thank you, yes it works, it was just my lack of understand as to where I had to place your code in the module area, but I have worked it out now. Thank you for your help.