+ Reply to Thread
Results 1 to 9 of 9

If cell contains specific text automatically copy row to different sheet

  1. #1
    Registered User
    Join Date
    10-16-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    If cell contains specific text automatically copy row to different sheet

    Hi,

    I'm really hoping for some help. Usually I don't have to use excel but at the moment I'm being given a lot of databases and spreadsheets to set up, which I have always managed to figure out. This problem seems to be way too complicated for my minimum knowledge.

    I have a workbook with various different sheets, which all have the same basic set up. Column E in every sheet is a drop down box with the options Outstanding, In Progress and Completed. What I need is for any row that has Outstanding or In Progress selected to be automatically copied onto my Summary sheet (preferably with an extra column to say which sheet the row is from. Though if this can't be done it's fine.)
    Also I would like for when an action is 'Completed' it is removed from the summary sheet.

    Am I asking for too much? Can this be done? Thank you in advance for any help or advise you give.

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: If cell contains specific text automatically copy row to different sheet

    Hi donzi

    Welcome to the Forum!!

    Paste the Code in the ThisWorkbook Module
    Go to VBA (Alt + F11)
    Left hand Panel select ThisWorkbook
    Paste the Code in the right hand window.
    Exit VBA (Alt + F11)
    Save the Workbook
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    10-16-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: If cell contains specific text automatically copy row to different sheet

    Hi John,

    Thanks for the help, but this code is deleting the rows from the original sheet. Am I able to keep them on the original sheet and copy them onto my summary?

    Thanks

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: If cell contains specific text automatically copy row to different sheet

    Hi donnzi

    I completely misread your requirements...sorry about that...

    Is Summary Sheet currently populated? Is there a Field on each sheet that's Unique? Can you upload a Sample Workbook?

  5. #5
    Registered User
    Join Date
    10-16-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: If cell contains specific text automatically copy row to different sheet

    Hi,

    At the moment I've not got any data in, so I'm happy to change things to make it easier to do what I need it to do.

    Please see the attached for what I have so far.

    Thanks
    Attached Files Attached Files

  6. #6
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: If cell contains specific text automatically copy row to different sheet

    Hi donnzi

    You are requesting
    when an action is 'Completed' it is removed from the summary sheet
    What makes this Action Unique...which of your Header(s) makes an Action Unique such that it can be found in the Summary Sheet?

  7. #7
    Registered User
    Join Date
    10-16-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: If cell contains specific text automatically copy row to different sheet

    Hi,

    What I need most is for any row on the 'site' sheets that has 'Outstanding' or 'In Progress' selected in column E to be copied on the 'summary' sheet automatically.

    Ideally, once these actions are marked 'Completed', they are automatically deleted from the summary sheet but remain on their original sheet.

    Am I making any sense?Sorry if I'm being difficult

  8. #8
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: If cell contains specific text automatically copy row to different sheet

    Hi donnzi

    Please put some Data in your Worksheets. The Data should be representative of your Actual Data.

  9. #9
    Registered User
    Join Date
    10-16-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: If cell contains specific text automatically copy row to different sheet

    If you go to the worksheet 'Site1' that has the example data in. That is what I need to be copied to the 'Summary' sheet.

+ 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. Copy specific numbers to a sheet automatically
    By ossa in forum Excel General
    Replies: 9
    Last Post: 06-12-2013, 09:55 AM
  2. Replies: 0
    Last Post: 03-12-2013, 04:29 PM
  3. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  4. When a date entered on a specific cell, automatically enter a text in other cell
    By mmccra2858 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2012, 09:57 AM
  5. Copy specific columns to specific cell on new sheet
    By jones_net in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2010, 02:34 AM

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