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
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Similar threads
- Question
- Question
- Solved
