Results 1 to 7 of 7

Sort results on seperate sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-16-2004
    MS-Off Ver
    2016
    Posts
    175

    Sort results on seperate sheet

    I have a result sheet where I want to extract the winner of races from sheet1 to sheet2. My result sheet is 50,000 lines long. See Sample for format.

    I want a macro to copy the line that is 2 spaces below the word "Name" that is repeated in Col A and is the separation between the races. Copy A:E there. Put that on sheet 2 Col A as shown in the sample. Then go back to sheet 1 and find the winner of the race which will be the one with a value in column B. Copy A:I there. Go to sheet2 and put that on the same line as the previous entry starting in Col F. Repeat Thanks.
    Attached Files Attached Files
    Last edited by light; 03-04-2023 at 10:29 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort Query Results to remove duplicate entries and put results on one line.
    By Panther70 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2015, 03:03 PM
  2. Replies: 4
    Last Post: 11-20-2012, 06:00 PM
  3. Unable to take results sheet and divided them into two seperate results
    By dannyboy1982 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-26-2012, 03:35 PM
  4. Inconsistent code results, saving sheet to seperate location
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2012, 07:34 AM
  5. Filtering Results and Copying Each Result to a Seperate Sheet
    By gjaylward2008 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-16-2012, 04:10 PM
  6. [SOLVED] Automatically duplicate and sort data into seperate w.sheet
    By Ting in forum Excel General
    Replies: 1
    Last Post: 06-20-2006, 09:20 PM
  7. [SOLVED] Sort out data on seperate sheet
    By Linda in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-13-2006, 01:15 PM

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