Linked Sheets, Sort Cells, Blanks to bottom

Hi Everyone,

I have a new spreadsheet I'm working on and I could use some help.

I'm creating an excel sheet that is linked to several others. Basically my salesmen will enter their new prospects into their own sales sheets and that will transfer via a link to my main one. The problem I'm having is mainly with my sort. When the information is transferred, I need the sheet to auto sort the Company names alphabetically and move any blank cells to the bottom.

Here's what I have so far in Visual Basic:

Please Login or Register  to view this content.

This should sort it and it does but it puts all of the blanks at the top and my data at the bottom. If I sort descending, then I get my Z's first and my A's last. I need to sort A - Z with the blanks to the bottom but of course all of those blank cells contain this data:

Please Login or Register  to view this content.

I've been working on this project for the better part of two weeks and it's due for presentation to the head of our department on Friday. Can you help me figure out a way to make this work? I'm willing to go back to the drawing board with code if I need to.

Thanks very much
Riv

1) Change the formula in A6 to: =IF(C6="","",0)
This will later cause empty rows to NOT be included in the sort, pushing them to the bottom.

2) Click on Tools > Options > View and uncheck the [ ] Zero values option (this applies to this sheet only)

3) To get your macro to sort first by column A with the now corrected 0s only and THEN by column C the names (results will be alphabetic), then this macro:

Please Login or Register  to view this content.