Hi, Can anyone tell me if its possible to sort a table of Named Ranges?
I have attached a sample of my data and it shows the before and after to get the desired result
Each Named Range has 3 rows and 12 columns. I want to sort on Column I(Largest to smallest) keeping the Named Ranges together.
Can anyone tell if this is possible please.
Seve
I don't think he problem here is the name ranges, it's more likely to be the merged cells.
Excel won't sort merge cells unless they 'are all the same size', whatever that means exactly.
I've you got rid of all the merging and filled in the blanks in the 'Overall Rating' column then you can sort no problem.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks