+ Reply to Thread
Results 1 to 5 of 5

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

  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

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

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

    Oh and to clarify, each cell I have has a few sentences. So if the word I look for shows up even once, I want all of the contents from that cell copied over to the new worksheet.

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

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

    This code creates copies the searched word in a summary sheet, so you need to create a sheet called "Summary", otherwise you will get an error.

    Please Login or Register  to view this content.

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

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

    This. is. perfect. Thank you so much AB33! Saved me 60 hours of manual labor on this! This forum rocks.

  5. #5
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

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

    You are welcome!

+ Reply to Thread

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