Thanks for the response Don but I what I failed to mention in my post is that
I have to create 6-10 workbooks from one file of 65000 rows, and I need to do
this with 8 original files, so to do it manually will take FOREVER - so I'd
rather automate it...


"Don Guillett" wrote:

Can you just use datafilterautofilter and filter on the city.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Louise" wrote in message
...
This is a long shot... But can anyone help me with a macro?

I have a set of data like the example below:

Name City Number

J Bloggs London 5
I Grass London 6
F Perry Manchester 2
L Owen Bournemouth 3
V Steele Liverpool 1

I need a macro to take the data and split it according to the City Name
and
put each section in a new workbook. So I need a workbook for London,
Manchester, Bournemouth & Liverpool in this instance with the relevant
data
pasted into it from the main sheet.

Is this possible and how would I go about creating this please?

I thank anyone for their help!!!