+ Reply to Thread
Results 1 to 2 of 2

Copying data if it matches criteria

  1. #1
    Registered User
    Join Date
    06-25-2008
    Posts
    2

    Copying data if it matches criteria

    Hi there, I can't seem to figure out what functions to use to accomplish this effect.

    One workbook sheet is a two column roster of names. Column one is "names" and column two is "medical needs?". Column two won't be filled in for every name.

    I can say in English "when column two has text in it, copy that whole row to another sheet that summarizes all students with medical needs". What I can't do is say that in Excel code.

    I want to pull out all rows of data where there is -anything- present in column #2, and paste those into a table on another sheet.

    How can this be accomplished?

    Thanks!

    Alex

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,286
    Hi,

    Try this:

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ 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 Specific Data To Another Sheet
    By vmc62 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-06-2013, 08:57 AM
  2. Cut Paste data basis criteria
    By shahcu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-31-2008, 02:22 PM
  3. Copying data from sheet to sheet using VB
    By EdMac in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 11-02-2007, 08:03 AM
  4. automatically copying data to history...
    By Spitfire999 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2007, 09:48 AM
  5. Need to extract random data using set criteria...
    By dance621 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2006, 06:03 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