Hey guys,
I'm definitely new to the forum and excel. I have been searching for awhile for an answer to this question. I'm not good at programming at all so trying to figure out things in Visual Basic is quite a task for me (I got a C in college on VB). Hopefully you guys can offer me some time saving advice
Right now I have three worksheets, I need to look through them for keywords, such as 'identity' (not case sensitive if possible, if not, then multiple instances, 'identity' and 'Identity'). After it finds these keywords, I need it to copy each entire cell that has any instance of the keyword showing up, and paste the cell into a new worksheet. I'm trying to organize notes for an MA thesis here and this would save me from manually going through over 150 pages of notes. Thanks for any suggestions or help!
Cheers,
Lars
Bookmarks