Help! It wont filter the blanks...

[dkballs]

Hi,
Please help.
I have a worksheet that has a few columns.

column A has names and column B has dates.
I have setup a macro as there are multiple worksheets in the workbook the same. The macro filters all the worksheets in ascending order.

The problem is if you clear contents of a row, when you filter it doesn't move the row to the bottom. it filters around it. This leaves the data looking patchy. Is there a way around this??

The worksheet is protected so that the users can't add things out of the rows etc. This means that they cant simply delete the row.

 

[Andrew Poulsom]

You need to sort your data ascending to move the blanks to the bottom.

 

[dkballs]

Any idea how to do that on Excel 2003? I've got an autofilter setup on the columns but when I sort ascending it's not moving them to the bottom.

 

[Andrew Poulsom]

Click the dropdown for the column that contains the blank cells and choose Sort Ascending.