Sort By Column A When Letter On End

[Dazzawm]

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

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

 

[JamesCanale]

Does it have to be a macro?

MrExcelPlayground20.xlsx
	A	B	C	D
1	Thing	ThingA	ThingB	ThingC
2	AUA316D 5005A	A	3	5
3	AUA316D 5005B	B	4	3
4	AUA320D 1032	C	2	2
5	AUA320D 1034	D	3	9
6	AUA320D 2001B	E	4	4
7	AUA320D 2030	F	5	5
8	AUA320D 2034	G	3	3
9
10
11	Thing	ThingA	ThingB	ThingC
12	AUA316D 5005A	A	3	5
13	AUA316D 5005B	B	4	3
14	AUA320D 2001B	E	4	4
15	AUA320D 1032	C	2	2
16	AUA320D 1034	D	3	9
17	AUA320D 2030	F	5	5
18	AUA320D 2034	G	3	3
Sheet13

Cell Formulas
Range	Formula
A12:D18	A12	=SORTBY(A2:D8,ISNUMBER(VALUE(RIGHT(A2:A8,1))),1,A2:A8,1)
Dynamic array formulas.

 

[Dazzawm]

Does it have to be a macro?

MrExcelPlayground20.xlsx
	A	B	C	D
1	Thing	ThingA	ThingB	ThingC
2	AUA316D 5005A	A	3	5
3	AUA316D 5005B	B	4	3
4	AUA320D 1032	C	2	2
5	AUA320D 1034	D	3	9
6	AUA320D 2001B	E	4	4
7	AUA320D 2030	F	5	5
8	AUA320D 2034	G	3	3
9
10
11	Thing	ThingA	ThingB	ThingC
12	AUA316D 5005A	A	3	5
13	AUA316D 5005B	B	4	3
14	AUA320D 2001B	E	4	4
15	AUA320D 1032	C	2	2
16	AUA320D 1034	D	3	9
17	AUA320D 2030	F	5	5
18	AUA320D 2034	G	3	3
Sheet13

Cell Formulas
Range	Formula
A12:D18	A12	=SORTBY(A2:D8,ISNUMBER(VALUE(RIGHT(A2:A8,1))),1,A2:A8,1)
Dynamic array formulas.

It does have to be a macro for use on many files of varying size.

 

[Dazzawm]

@JamesCanale
Are you able to write a macro please?

 

[JamesCanale]

I'm terrible at VBA.

 

[Dazzawm]

Hopefully someone will come to my rescue!

 

[JamesCanale]

You might rethread this then.

 

[Dazzawm]

You might rethread this then.

What you mean?

 

[JamesCanale]

Ask the question again in a new thread. People tend to look at unanswered more than answered questions.

 

[Dazzawm]

Ask the question again in a new thread. People tend to look at unanswered more than answered questions.

That's not allowed I don't think.