Find data in column and move rows

Topic

New Reply

Morning all

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.

Any pointers please

Reply | Quote

Replies

See if you can adapt the code from Seperate Data (the attachments in that topic have been lost, but the code is still available).

Reply | Quote

See Advanced Usage Help for tips on how to enter search criteria.

Reply | Quote

Hi Hans

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.

Reply | Quote

The code will have to be adapted for your purposes. I don’t understand your question well enough to suggest how, I’d need to have more information.

Reply | Quote