Sort data w/ correct starting row

[gtd526]

Hello,
I want to sort by G/L % (L:L), it sorts correctly but the sort begins in row 13, when it should be line 9. How can I make the sort start on line 9?
Thank you.

Here is the data Im working with:

The Whole Enchilada.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
8	Symbol	Sector	Type	Shares	Cost	CURRENT	MAX Value	MIN Value	Cost Value	Market Value	Gain/Loss	G/L %	Weight(%)	Expiration	Strike	Expires in:
9					$ -	$ -	$ -	$ -	$ -	$ -	$ -
10					$ -	$ -	$ -	$ -	$ -	$ -	$ -
11					$ -	$ -	$ -	$ -	$ -	$ -	$ -
12					$ -	$ -	$ -	$ -	$ -	$ -	$ -
13	UKPIX	Bear Mkt	Bear	10	$ 11.66	$ 12.12	$ 12.29	$ 11.66	$ 116.60	$ 121.20	$ 4.60	3.95%	4.6%
14	UVPIX	Bear Mkt	Bear	10	$ 20.97	$ 21.62	$ 21.80	$ 20.83	$ 209.70	$ 216.20	$ 6.50	3.10%	8.2%
15	UHPIX	Bear Mkt	Bear	10	$ 14.15	$ 14.56	$ 14.81	$ 14.15	$ 141.50	$ 145.60	$ 4.10	2.90%	5.5%
16	UXPIX	Bear Mkt	Bear	10	$ 22.46	$ 22.87	$ 23.12	$ 22.35	$ 224.60	$ 228.70	$ 4.10	1.83%	8.8%
17	GSSFX	Bear Mkt	Bear	10	$ 5.81	$ 5.84	$ 5.85	$ 5.81	$ 58.10	$ 58.40	$ 0.30	0.52%	2.3%
18	URPIX	Bear Mkt	Bear	10	$ 21.78	$ 21.82	$ 22.19	$ 21.72	$ 217.80	$ 218.20	$ 0.40	0.18%	8.5%
19	RYAPX	Bear Mkt	Bear	10	$ 21.93	$ 21.97	$ 22.21	$ 21.89	$ 219.30	$ 219.70	$ 0.40	0.18%	8.6%
20	UWPIX	Bear Mkt	Bear	10	$ 20.59	$ 20.62	$ 20.82	$ 20.54	$ 205.90	$ 206.20	$ 0.30	0.15%	8.0%
21	GRZZX	Bear Mkt	Bear	10	$ 6.99	$ 7.00	$ 7.10	$ 6.99	$ 69.90	$ 70.00	$ 0.10	0.14%	2.7%
22	RYARX	Bear Mkt	Bear	10	$ 28.45	$ 28.49	$ 28.71	$ 28.41	$ 284.50	$ 284.90	$ 0.40	0.14%	11.1%
23	SOPIX	Bear Mkt	Bear	10	$ 14.23	$ 14.25	$ 14.42	$ 14.21	$ 142.30	$ 142.50	$ 0.20	0.14%	5.6%
24	RYAFX	Bear Mkt	Bear	10	$ 54.05	$ 54.06	$ 55.90	$ 54.05	$ 540.50	$ 540.60	$ 0.10	0.02%	21.1%
25	UCPIX	Bear Mkt	Bear	10	$ 7.26	$ 7.25	$ 7.77	$ 7.25	$ 72.60	$ 72.50	$ (0.10)	-0.14%	2.8%
26	UIPIX	Bear Mkt	Bear	10	$ 5.52	$ 5.49	$ 5.75	$ 5.49	$ 55.20	$ 54.90	$ (0.30)	-0.54%	2.2%
27									$ 2,558.50	$ 2,579.60	$ 21.10	0.82%
Bear Mkt

Cell Formulas
Range	Formula
G9:G26	G9	=IF($F9=0,0,MAX($F9,$G9))
H9:H26	H9	=IF($H9=0,$F9,MEDIAN($H9,$F9,0))
I13:I26,I9:I10	I9	=(E9*D9)
J9:J26	J9	=F9*D9
K9:K26	K9	=J9-I9
L9:L26	L9	=IF(K9<>0,K9/I9,"")
M9:M26	M9	=IF(I9<>0,I9/$I$27,"")
P9:P26	P9	=IF(OR($N9="",$N9="sold"),"",$N9-TODAY())
Q9:Q26	Q9	=IF(OR($N9="",$N9="sold"),"","day(s)")
F13:F26	F13	=VLOOKUP($A13,$A$53:$B$68,2,0)
B9:B26	B9	=IF(COUNTIF(Sectors!$A$3:$AA$50,A9)=1,INDEX(Sectors!$A$2:$AA$2,MAX((Sectors!$A$3:$AA$50=A9)*(COLUMN(Sectors!$A$2:$AA$2)))),"")
I27:K27	I27	=SUM(I9:I26)
L27	L27	=IFERROR((K27/I27),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D9:D26	Cell Value	="put"	text	NO
D9:D26	Cell Value	="call"	text	NO
B9:B26	Expression	=$N9="sold"	text	NO
B9:B26	Expression	=MOD(ROW(),2)=1	text	NO
A9:A26	Expression	=$N9="sold"	text	NO
A9:A26	Expression	=MOD(ROW(),2)=1	text	NO
C9:C26	Cell Value	="put"	text	NO
C9:C26	Cell Value	="call"	text	NO
I9:O26,C9:E26	Expression	=$N9="sold"	text	NO
F9:F26,H9:H26	Expression	=$F9=$H9	text	NO
F9:G26	Expression	=$F9=$G9	text	NO
I9:O26,C9:E26	Expression	=MOD(ROW(),2)=1	text	NO
L27	Cell Value	<0	text	NO
L27	Cell Value	>0	text	NO
K27	Cell Value	<0	text	NO
K27	Cell Value	>0	text	NO
D1,K9:L26	Cell Value	<0	text	NO
D1,K9:L26	Cell Value	>0	text	NO
K8:L8	Expression	=AVERAGE(K9:K26)<0	text	NO
K8:L8	Expression	=AVERAGE(K9:K26)>0	text	NO

Here is the Macro:

Sub BearMkt_Sort_by_Gain()

    Workbooks("The Whole Enchilada.xlsm").Worksheets("Bear Mkt").Select
    
    Range("A9:Q26").Select
    ActiveWorkbook.Worksheets("Bear Mkt").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Bear Mkt").Sort.SortFields.Add2 Key:=Range("L9:L26") _
        , SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Bear Mkt").Sort
        .SetRange Range("A9:Q26")
'        .Header = xlNo
'        .MatchCase = False
'        .Orientation = xlTopToBottom
'        .SortMethod = xlPinYin
        .Apply
    End With
    Range("A9").Select
End Sub

 

[daregu]

filter out the zero values and your done.

 

[gtd526]

filter out the zero values and your done.

How do you do that? I get my macro's online by search.