Sort range with data validation automatically

[ctroxtell]

Can you enforce a sort option on a range of cells that have data validation on them? i.e. I have a range that has multiple building addresses that can be selected, is there a way to ensure it sorts the range so that if I select 605 Main St, 910 Main St and 101 Main St in that order that it will automatically sort them in ascending order?

 

[Skyybot]

Format as Table. Sort by Address. Validation should follow.

 

[Skyybot]

Or a simple Columns select and Sort should suffice. Excel will ask if you want to expand selection. Click yes.

 

[ctroxtell]

My issue is that I cannot select the entire address column, in the table I have properties that are (FS)full service addresses and below that are properties with (LO)lease oversight addresses. I do not want those two properties sorted together. Currently it is running data validation in the selected areas so that the FS address cannot be selected in the LO area of the table. Can it sort this without being told to sort it each time?

 

[Skyybot]

Can you post a copy of your data? I cannot see what you're seeing. FS and LO mean nothing to me.

 

[ctroxtell]

Whenever I make the selection of addresses I want it to sort them numerically but I do not want it to mix the FS and LO properties together.

My Copy of Engineer Alignment Wake Nov.xlsx
	F	G	H
68	Open
69
70
71	Bldg #	Address	S/F
72	FS	2000 Cloverdale Ave (Winston)	5,961
73	FS	2200 Cloverdale Ave (Winston)	75,816
74	FS	403 S Hawthorne Rd (Winston)	4,502
75	FS	1920 Queen St (Winston)	2,506
76	FS	231 Melrose St (Winston)	10,552
77	5	Total Square Footage FS	99,337
78	LO	1126 North Church Street (Greensboro)	4,792
79	1	Total Square Footage LO	4,792
80
81	6	Grand Total	104,129
Hiatt

Cell Formulas
Range	Formula
F72:F76	F72	=IFERROR(VLOOKUP(Hiatt!$G72,Table1,3,FALSE),"")
F77	F77	=COUNTA(F72:F76)
F78	F78	=IFERROR(VLOOKUP(Hiatt!$G78,Table12,3,FALSE),"")
F79	F79	=COUNTA(F78)
H72:H76	H72	=IFERROR(VLOOKUP(Hiatt!$G72,Table1,2,FALSE),"")
H77	H77	=SUM(H72:H76)
H78	H78	=IFERROR(VLOOKUP(Hiatt!$G78,Table12,2,FALSE),"")
H79	H79	=SUM(H78)
F81	F81	=SUM(F77+F79)
H81	H81	=SUM(H77,H79)

Cells with Data Validation
Cell	Allow	Criteria
G72:G76	List	=$AB$17#
G78	List	=$AH$17#

 

[ctroxtell]

So in essence, I have a sheet with multiple employee tables. Each table has a list of FS properties listed and LO properties listed. I want to keep the FS and LO addresses separate (this is done with data validation running on the cells). But I want the cells to automatically sort as they are selected from the data validation drop down menu. Is this possible?