Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I have column A with data of varying lengths. I need a macro please that will sort the entire sheet by column A when there is a letter on the end like below first. I have highlighted for clarity once sort is done. Thanks
Before
After
Before
AUA316D 5005A |
AUA316D 5005B |
AUA320D 1032 |
AUA320D 1034 |
AUA320D 2001B |
AUA320D 2030 |
AUA320D 2034 |
After
AUA316D 5005A |
AUA316D 5005B |
AUA320D 2001B |
AUA320D 1032 |
AUA320D 1034 |
AUA320D 2030 |
AUA320D 2034 |