Moving row to different sheets depending on number in column A

Hi
I have attached a small workbook,

I have to copy around 1000 rows of data each month and split them manualy, is there a way i
could drop all data in the first sheet then at a press of a button all rows from column b-k would be moved into
different sheets depending on the number in column A
i.e 40 = bradford 45=hull 46 = york etc there are 16 different groups that i will eventually add to the work book


Thanks for any help on this

Peter

Quote:

---

Originally Posted by peter renton

Hthere are 16 different groups that i will eventually add to the work book

---

if you add them it will be very simple