I have 4 columns in this workbook and I'd like to be able to sort a specific column alphabetically and have the contents of the rows switch with them. Does that make sense?
Everything in column A is an item that is unique, column B is the location of those items. I want to sort those items by location, so when I sort B alphabetically, I need A to still correspond.
Any help is appreciated!
The key to sorting and retaining related data is to make sure all of the columns you want maintained are selected... so if you have related data in columns A, B, C and D, and you want to sort by column B, make sure ALL 4 columns are highlighted before you sort.
- Moo
isn't that when you sort it ask if you want to expand the selection or continue with the current selection. did you tried expand the current selection when sorting? Or there is another you want?
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
That was the trick, Moo. Thanks!Originally Posted by Moo the Dog
You're welcome!
- Moo
- - - - - - - - - -
If you are satisfied with the solution(s) provided, please mark the thread as [SOLVED] by clicking on the words 'Thread Tools' above your 1st post in this thread. Then select 'Mark Thread as Solved'.
Also, a good way to 'Say thanks' to those who have helped is to click on the star below their name in one of their posts. It's always appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks