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.
Bookmarks