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! :-)