I was sure that a solution to my problem had been asked a short while ago but I can't seem to find it, I have tried 'Find Data'. 'Move Rows' etc. without any joy. Can anybody help with the following please.

I am going to be sent spreadsheet every month with a column called 'Service' which will contain service codes but they will not be constant every month. An example may be

INTL-UK
UK-UK
HOS-UK
IIE-UK
IIN-SG

What I would like to achieve is to be able to search a specific column and then move all rows whose column I have specified to a new worksheet named after the column search.

For example, search for UK-UK, 53 records identified, new worksheet created called UK-UK, 53 records copied or deleted and moved.

Thanks for the response, I am on a course this week so will have a proper try with the example when I am on holiday next week. I did have a quick try and changed the worksheet name in the code and it erased everything in the workbook, luckily it was a copy, phew.