Hi,
I would like to create a VBA macro button which would sort a column contained letters and numbers, and return letters sort on the top of the column followed with the numbers. See this example below.
Column A
Allan Jack
Ben Jack
Adrien Om
Olivia McCartney
Debora Elisabeth
Mark Dan
Apple Danny
Carolina Edith
Zebra Zeng
Brian Bransc
Benito Martinez
Karin Orth
Maria McCleman
Dave Bond
Eva Laura
45
Jack Clod
20
1
52
3
0
Result after running the macro:
Column A
Adrien Om
Allan Jack
Apple Danny
Ben Jack
Benito Martinez
Brian Bransc
Carolina Edith
Dave Bond
Debora Elisabeth
Eva Laura
Jack Clod
Karin Orth
Maria McCleman
Mark Dan
Olivia McCartney
Zebra Zeng
45
20
1
52
3
0
Thanks in advance for your help.
Ferddy.
Bookmarks