making a button to split data into seperate sheets

I would like to make a button in the top corner fo my worksheet 1 thats would read down column A and send the data of each type to a new sheet. (i.e a new tab at the bottom).


My data covers 17 different branches all with unique names, so i would like to to search down and make a copy of all data under london and place in a new tab preferably called london with the data displayed. I need it to make seperate sheets for each of the branches so at the end i would be left with 18 sheets on my workbook.

1st sheet: Total data
2nd sheet: just london
3rd : just birmingham

and so on.

Firstly is this possible and more importantly what should i be looking at or how the hell do i do it!

my main data (sheet one) has headers above each column can i take these to the other sheets or do i need to copy and paste these manually.

Thanks guys! :-)

Originally Posted by VBA Noob

Manually you can take a look at Data > Filter > auto Filter

But if you did it often take a look at the link below the heading "Create a new sheet for all Unique values"

http://www.rondebruin.nl/copy5.htm

VBA Noob

brilliant, will look over this tonight, im doing it every week or i mean i will be doing it every week so with over 4000 records some sort of automation would be handy