Results 1 to 5 of 5

Sort Worksheets by Date and then create summary worksheet with results

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-10-2014
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2205 Build 16.0.15225.20368) 64-bit
    Posts
    101

    Sort Worksheets by Date and then create summary worksheet with results

    Hello,

    I am trying to see if there is a way in which I can sort all of my worksheets by date that is within row 2 going from earliest date to latest date. I would like for it to sort the worksheets in that order and also once the task has been performed to create a summary worksheet with the sheet name and the first date listed within that players worksheet. I have attached the worksheet to use as a point of reference. I appreciate any help with this and Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort Rows and copy sort results to new worksheet?
    By Apache_sim in forum Excel General
    Replies: 0
    Last Post: 06-30-2015, 03:17 AM
  2. Create A Summary sheet from variable worksheets
    By kammariarun in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-19-2015, 03:44 PM
  3. VBA Code to Create One Summary worksheet of many worksheets in workbook
    By brandnew22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2014, 06:58 PM
  4. Macro to average a column in each worksheet and paste results in a summary sheet
    By mpigott in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-20-2013, 04:07 PM
  5. Extract data from worksheets to create a summary sheet
    By sniffer in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-28-2013, 07:17 PM
  6. Summary sheet to create multiple worksheets
    By originata in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2012, 05:42 PM
  7. create yearly summary from monthly worksheets
    By Chys in forum Excel General
    Replies: 1
    Last Post: 09-15-2005, 09:54 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