Results 1 to 5 of 5

Copy specific cells based on one word in the cell, to a different worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2013
    Location
    Texas, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Copy specific cells based on one word in the cell, to a different worksheet

    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
    Last edited by Lfaulst1; 03-30-2013 at 05:04 PM. Reason: spelling

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1