+ Reply to Thread
Results 1 to 4 of 4

How do I sort data to another sheet?

  1. 10-29-2016, 02:03 PM #1
    db21
    db21 is offline
    Registered User
    Join Date
    10-29-2016
    Location
    NORTH CAROLINA, USA
    MS-Off Ver
    MS OFFICE FOR MAC 2011
    Posts
    1

    How do I sort data to another sheet?

    Hello!

    I need HELP!

    In one file I have 3 sheets: Enrollment Report, Summary, Sum Sorted - the columns on both the "Summary" & "SumSorted" Sheet are the same: LName, FName, Date of Entry, Total Hours

    I was able to move the information from the Enrollment Report to the Summary Sheet...now I need the exact information that is on the Summary Sheet to be placed into the SumSorted Sheet, BUT I need it sorted by LName then FName...I know how to Sum the Total Hours at the bottom, but I don't know how to have the names automatically sorted on the SumSort Sheet.

    Can anyone help me with this?
    Attached Files Attached Files
    Last edited by db21; 10-29-2016 at 02:58 PM. Reason: attach sample spreadsheet
    Reply With QuoteRegister To Reply
  2. 10-29-2016, 04:27 PM #2
    popipipo
    popipipo is offline
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,324

    Re: How do I sort data to another sheet?

    Have you tried to solve it with a pivot table?
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong
    Reply With QuoteRegister To Reply
  3. 10-29-2016, 05:36 PM #3
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: How do I sort data to another sheet?

    Here's one way ...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 10-29-2016, 07:21 PM #4
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: How do I sort data to another sheet?

    Here is a method that doesn't rely on an INDEX column (A with all the periods).
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to sort raw data, remove duplicates and paste 2 specific data on a different sheet
    By bimmy80 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-25-2015, 02:08 AM
  2. match/sort - lookup data from one sheet and link to other sheet -
    By javaidmr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2015, 10:04 AM
  3. Sort data on one sheet by a list on another sheet
    By derpygoat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-06-2014, 01:42 PM
  4. Sort the data in different sheet as per first sheet selection list
    By mau_0 in forum Excel General
    Replies: 0
    Last Post: 01-10-2013, 01:39 AM
  5. [SOLVED] Sort data in every sheet except one
    By djsli in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 01:07 PM
  6. How to sort one sheet using data from another
    By artj in forum Excel General
    Replies: 2
    Last Post: 11-17-2007, 07:14 PM
  7. Help to sort out filtered data from the data contained in another sheet of the same workbook
    By No News in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-28-2006, 11:10 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1