I'm new at this and I am trying to consolidate multiple sheets into one... When I start selecting references, they always revert to alphabetical, starting with the name of the sheet... How can I make these chronological without changing the names of my sheets? Example... I have my sheets named by month - April, May, June, etc... - they keep going to alphabetical, so I have to move columns around in the consolidated sheet.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sorting references when consolidating spreadsheets
- Thread starter Shawn B
- Start date
I'm new at this and I am trying to consolidate multiple sheets into one... When I start selecting references, they always revert to alphabetical, starting with the name of the sheet... How can I make these chronological without changing the names of my sheets? Example... I have my sheets named by month - April, May, June, etc... - they keep going to alphabetical, so I have to move columns around in the consolidated sheet.Excel Facts
Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Similar threads
- Question
- Question
