Macro to select cells with active data only across static number of columns but variable rows and then sort the selection

[Maverick79]

Hello all. Hoping you can help a newbie to macros . I am trying to create a macro which will select and sort only the active cells in a table with headers across a set number of columns but with variable rows depending if there is any active data in the first cell of the row. I have tried to separate the steps and then combine by calling the next macro but run into errors. The first column should have no gaps in the list data, but the other columns may have blank cells. I want to select all columns based on number of rows with active data in first column and sort in ascending order by the last column (Month), but if month cell is blank this row should be last in sorted selection.

Order Number	Chassis	Brand	Month
8888888	521345	xyz	1
9999999		xyz
7777777	854923	abc	8

Thanks in advance for your help!