Data sort, moving "empty" formula cells to bottom

Hope all is well. I've been frustrated trying to figure this out and was hoping someone could assist me. My basic issue is that I need to do a descending sort for a table but I keep getting blank rows above the data. I've attached the sheet so you can reference it.

Cells B5:16 contain drop downs linking to the sheet "Data." Basically you select the items you want in the drop down from in B5:B16, then click the "SORT DATA" button. The data is filled using the index/match combination. A user may only use for example 9 out of 12 rows. The issue is when I sort the data descending by column M I get in this case 3 empty rows on top because there are index/match formulas in the "empty" cells.

How do I edit my code so that if a cell appears to be empty in column M for example that entire row gets sorted to the bottom of the list.

Any help would be much appreciated! I've been googling and reading for days and I can't get it to work right.

Try this code:

Please Login or Register  to view this content.

The idea is to do 2 sorts: the first sorts on column B (in case a row was skipped) to bring the fund names together starting in first row. Then the second sort only sorts on the used rows (based on the number of funds selected in column B - the "n" value used in the code).