I have a worksheet that contains one column of data which consists of hyperlinks. Each link contains a description of what it is at the beginning followed by the link. For example:

Dog Toy: http://abcd.com/1234
Dog Toy: http://abcd.com/5678
Cat Toy: http://abcd.com/4567
Cat Toy: http:/abcd.com/2345

I want to be able to copy links to individual worksheets based on the text before the semicolon. I thought there was a formula to do this as I thought I had done it a while ago, but I can't find it. I don't know enough about VBA to write something to do it. I know enough to be dangerous and could probably figure out how to add things to a script but not enough to start from scratch.

I also need to delete data that meets certain criteria. I am doing it the long way right now by using filters. Is there a way to set up a macro to do this for me? I had it set up in word but would prefer to do it all in Excel and can't seem to get it.

Thanks in advance for any help you can offer.