I am trying to sort my worksheet by columns and it appears that columns that have recently been added are not sorting with the rest. It appears that they need to be added to the worksheet field somehow. Can someone tell me how to do that? Thank you so much!
Craig
how are you sorting? Via a macro or by highlighting all columns and then doing a sort? Maybe post the sheet to be looked at - or a sample?
I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!
Please mark your threads as Solved once it is solved. Check the FAQ's to see how.
When I select all of the columns, row1 goes to the bottom of the worksheet. Here it is. Please advise. Thank you!
Craig
Last edited by NBVC; 06-16-2009 at 11:46 AM. Reason: Confidential attachment
Any ideas yet?
Thanks
Craig
When I highlight all the columns A:O and click SORT, it sorts fine. Your row1 column labels do not seem to move as you've described.
You have a blank row2 that moves to the bottom, which is where it belongs. No blank rows allowed at the top of a sorted dataset.
I can't find anything wrong with the sorting.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks