+ Reply to Thread
Results 1 to 3 of 3

Selecting Data that fits a criterion

  1. #1
    Registered User
    Join Date
    05-31-2007
    Posts
    44

    Selecting Data that fits a criterion

    Hello.

    Please see the attached Excel file.

    Here, there are 3 sheets, "Score", "Students" and "Output".

    I would appreciate it very much if you could help me with the VBA code that can do this:

    Based on the list of names in "Students", go through the source data in "Score" to pick up the scores of the names that matches those in "Students" and publish these into "Output".

    For example, the "Students" sheet here has 3 names (Luis Jamil, Michael Sin and Rebecca Holdom). Using the data from the "Score" sheet, the following would be published into columns A and B of "Output":

    Name Score
    Luis Jamil 35%
    Michael Sin 47%
    Rebecca Holdom 24%



    Thank you very much
    Attached Files Attached Files
    Last edited by VBA Noob; 09-05-2008 at 12:52 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Blurtoad,

    This macro will copy the scores of the students to the Output sheet. It is already added to the attached workbook.
    Please Login or Register  to view this content.
    To Run the Macro...
    To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

    Sincerely,
    Leith Ross
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-31-2007
    Posts
    44

    Works brilliantly!

    Thank you so much.

+ 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. Charts that call data from a variable number of workbooks?
    By Schwavan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-11-2008, 12:31 PM
  2. importing data:What i would like to do is be able to import
    By censura in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2007, 08:32 AM
  3. Selecting data w/criteria and making chart.
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2007, 09:33 PM
  4. Help selecting random rows of data
    By hnoshea in forum Excel General
    Replies: 2
    Last Post: 10-04-2006, 03:18 PM
  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