VBA to sort with certain requirements (workbook attached)

Hi,

Please see the attached workbook. I am trying to determine what would be the VBA to sort data in A5:L34 considering the following:

1. The range will always be A5:L34, but the rows containing all zeroes will change frequently.
2. The zero rows will always start after all pertinent data to be sorted (there will never be zero rows between rows of data)
3. The sub-range of A5:L34 (in the case of the attached, A5:L11) which contains non-zero rows should be sorted alphabetically, first by column C, then by column D.

After the sort is done, I'd then want to clear all zero rows so all that's left is rows with data, sorted alphabetically as outlined above.

Is this do-able? Where I'm struggling is no matter what I try, it always wants to put the cells with the zeroes at the top of the sort.

Thanks.

Can use this

Please Login or Register  to view this content.

Kind regards
Leo

Here's how I read your question

Please Login or Register  to view this content.

Originally Posted by LeoTaxi

Can use this

Please Login or Register  to view this content.

Kind regards
Leo

Thank you Leo, this works exactly as I described. Very well done!

Easy job with good description and file

can you mark the case as solved ?

thanks
Leo