+ Reply to Thread
Results 1 to 7 of 7

If group of words is listed in cell, color row red then move whole row to another sheet.

  1. #1
    Registered User
    Join Date
    08-24-2022
    Location
    hugo
    MS-Off Ver
    13
    Posts
    40

    Post If group of words is listed in cell, color row red then move whole row to another sheet.

    ***I'm adding more to this, My code works but I also need to make the row red before copying it over to the new sheet OR even better, have the row be "moved" instead of just being copied. Thoughts on how I can add this to the current code?

    If a cell in column L has a certain group of words in it, I would need a new sheet created and the whole row would need to be copied to that along with the headers.
    I have a mocked up file attached.

    Here is an example:
    If a cell in column L contains "Hello World" and "My name is Sally" Anywhere, I would like a new tab/sheet created Named "NewTabName" and the whole row/s copied to it along with the header row.


    This is similar to another issue I had that was solved, but in that case the cell only had 1 number verses a long sentence. In case seeing that code helps and it may just need to be tweaked, the thread is
    I can't post the link to the thread yet, but here is the title "If certain value in cell then copy full row to another sheet"


    Thanks to anyone who can help!
    Attached Files Attached Files
    Last edited by excelgirl84; 08-25-2022 at 08:50 PM. Reason: I solved this!

  2. #2
    Registered User
    Join Date
    08-24-2022
    Location
    hugo
    MS-Off Ver
    13
    Posts
    40

    Re: If certain group of words is listed in cell, move whole row to another sheet.

    Please Login or Register  to view this content.

  3. #3
    Valued Forum Contributor
    Join Date
    05-03-2022
    Location
    Halifax,Canada
    MS-Off Ver
    365
    Posts
    326

    Re: If certain group of words is listed in cell, move whole row to another sheet.

    Hello excelGril84 ... looks familiar ... LOL

    https://www.excelforum.com/excel-pro...ml#post5717751

  4. #4
    Registered User
    Join Date
    08-24-2022
    Location
    hugo
    MS-Off Ver
    13
    Posts
    40

    Re: If certain group of words is listed in cell, move whole row to another sheet.

    [QUOTE=nimrod1313;5718217]Hello excelGril84 ... looks familiar ... LOL



    Yes, very similar. Just had to make some changes to your code and got it working for this as well! Thanks!

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: If certain group of words is listed in cell, move whole row to another sheet.

    Quote Originally Posted by excelgirl84 View Post
    ***edit, this has been solved. I'll post sample code soon.
    Simple use of AdvancedFilter and it is very fast.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-24-2022
    Location
    hugo
    MS-Off Ver
    13
    Posts
    40

    Re: If certain group of words is listed in cell, move whole row to another sheet.

    Quick question. Using my code, do you know how I could add this to it?

    Before copying the row to the new sheet, color the row RED (so its red on the original sheet) Thoughts?

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,523

    Re: If group of words is listed in cell, color row red then move whole row to another shee

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to count all 2 letter words in a cell or group of cells.
    By njc315 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-20-2019, 07:11 PM
  2. Generate random group of words in a cell from a large group word list in column
    By faizzsheikh in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-26-2018, 10:16 AM
  3. [SOLVED] Looking for Help to find a set of words within a string, and move to another sheet
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-09-2015, 12:25 PM
  4. [SOLVED] delete entire row if it doesn't contains at least 1 of the words listed
    By 4evra in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-30-2013, 02:14 PM
  5. [SOLVED] Move and Group duplicate data into a table on same sheet?
    By balston2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2013, 02:10 PM
  6. Replies: 6
    Last Post: 10-19-2012, 05:19 AM
  7. How can I hide the words of a cell (or a group of cells)...
    By Octavio in forum Excel - New Users/Basics
    Replies: 15
    Last Post: 01-22-2006, 03:55 PM

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