I have a table which increases in size as more data gets added. 2 Columns have 2 rows that have been merged but the rest are individual rows. Is there a way I can sort the columns with column E being alphabetical? Many thanks for any solutions
-
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.
Sort Columns with some merged rows
- Thread starter Andy248
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 72,244
- Office Version
- 365
- Platform
- Windows
Welcome to the Board!
The best thing to do is to get rid of the merged cells. Merged cells are an ABSOLUTE NIGHTMARE for Excel, wreaking all sorts of havoc with things like sorting and VBA.
It is highly, HIGHLY recommend that you get rid of them (most serious programmers will never use them, and many will not even touch any questions dealing with them).
You can probably remove them/clean them up with VBA code.
If you are interested in that, post a small sample of your data, and someone here should be able to help you with that code.
The best thing to do is to get rid of the merged cells. Merged cells are an ABSOLUTE NIGHTMARE for Excel, wreaking all sorts of havoc with things like sorting and VBA.
It is highly, HIGHLY recommend that you get rid of them (most serious programmers will never use them, and many will not even touch any questions dealing with them).
You can probably remove them/clean them up with VBA code.
If you are interested in that, post a small sample of your data, and someone here should be able to help you with that code.
Upvote
0
