Select a column of data, including the title and blank rows, apply a Filter
(Data | Sort & Filter | Filter), in the filter drop-down menu in the title
row uncheck (Blanks), apply your sort, deselect the filter (Excel 2007).
--
Gnothi se auton.


"WLMPilot" wrote:

I have a budget within a worksheet. I want to have the capability to sort
each column, acending or decending. Other than creating two macros per
column is there a way to do this. The number of rows will vary, but I only
want to include the rows that have data in them. Currently, columns are A-P
and rows are 9 - 34. Again, as needed, rows will be added.

Thanks for your help,
Les