Results 1 to 1 of 1

Grabbing and sorting info from another worksheet.

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2008
    Location
    Wooster, OH
    Posts
    22

    Grabbing and sorting info from another worksheet.

    Generally speaking, I want to grab information from the Batting and Pitching Register worksheet, sort it, and place it into the League Leaders worksheet. Example:

    In cells K14-K23 in the League Leaders worksheet, I want to grab the ten highest HR totals from the Batting and Pitching Register HR column, cells H5-H139. They are to be placed in K14-K23, sorted from the highest to the lowest. Then, in cells I14-23, the Player (column B on the Batting and Pitching Register) and Team (column C) corresponding to each of these numbers must be placed, thusly: Aaron, MIL

    I know this one might be complex, but I'd appreciate any help that I can get. If someone can show me how to do it with the Homeruns, I can probably figure how to do it with the other categories.

    Thanks, Jack
    Attached Files Attached Files

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