+ Reply to Thread
Results 1 to 2 of 2

Copying data to a new sheet based on a condition

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    United States
    MS-Off Ver
    Excel 2011
    Posts
    3

    Copying data to a new sheet based on a condition

    Hi I am trying to copy data from one sheet to another, but only if one value fits a certain criteria.
    I do not want any blanks in the data

    example sheet 1:

    A B C
    1 Jim yes
    2 Joe no
    3 John yes
    4 Jake no

    example sheet 2: Only if(c="yes")

    A B
    1 Jim
    2 John

    NOT:

    A B
    1 Jim
    2
    3 John
    4

    Thanks in Advance!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Copying data to a new sheet based on a condition

    I'd suggest you use AutoFilter. Filter on column C = "yes"; select the visible cells and copy and paste them wherever you want.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Copying rows from sheet 1 to sheet 3, based on if condition.
    By Mooohan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2015, 11:57 AM
  2. help with data copying one sheet to another based on condition
    By azegurb in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-24-2014, 05:48 AM
  3. Copying the data from one sheet to another on the basis of yes/no condition
    By shantnuchaurasia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2013, 12:32 PM
  4. Copying data from one workbook to another based on condition
    By AndyE in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2013, 10:29 AM
  5. copying data from 1 sheet to another based on condition by VB Macro
    By kavya_2009 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2011, 04:46 PM
  6. Copying Rows to New Sheet Based On Condition
    By Az_Outlaw in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-29-2010, 04:06 PM
  7. Copying rows to new sheet based on condition
    By nraz76 in forum Excel General
    Replies: 5
    Last Post: 10-20-2009, 11:29 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