+ Reply to Thread
Results 1 to 6 of 6

Copying row of data to new sheet if specific value exists in column

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    5

    Smile Copying row of data to new sheet if specific value exists in column

    HELP PLEASE!!!

    On the attached workbook, I'd like to make other sheets read from the full list in the original sheet like so:
    Sheet2 would look in Column C of Sheet1 for "Not Sent", any rows that are labeled that way would be copied to Sheet2.

    I don't know if I'm asking it to do too much or if my brain just isn't working for me today!!!

    Any suggestions would be greatly appreciated. Thanks!

    Proposal Log.xlsx
    Last edited by raz333; 05-10-2013 at 04:31 PM. Reason: Solved

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Copying row of data to new sheet if specific value exists in column

    run this macro..
    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,903

    Re: Copying row of data to new sheet if specific value exists in column

    You can also use the filterfunction in sheet1
    The result is the same
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    05-10-2013
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Copying row of data to new sheet if specific value exists in column

    rcm...THANK YOU, that is perfect! :-)

    popipipo...That is typically a much larger file with filtered information. I am aware that I could continuously filter to what I needed but that wasn't the result I was asking for, I needed it on separate sheets.

  5. #5
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Copying row of data to new sheet if specific value exists in column

    glad to be of help

  6. #6
    Registered User
    Join Date
    05-10-2013
    Location
    Wisconsin
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Copying row of data to new sheet if specific value exists in column

    Hello again,
    After a busy week I was finally able to look at the project that I needed this for. I have found that the macro only fills the data in once. I need it to update the sheets based on changed information from sheet one. Basically, the Project Status is constantly changing and I want the subsequent sheets to reflect that. Is that possible??

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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