Advace Sorting Based On Values

Hi

I get workbooks with three kinds of data in a certain column in every workbook. The data is positive, neutral and negative, i.e., 20, 0, -20, respectively. The values are always in the B column.

I was wondering if a macro can do the following:

1 Sort positive data (highest to lowest) (anything greater than zero)
2 Delete rows of neutral data (0)
3 Sort negative data (lowest to highest) (i.e, -20, -18, -12, -7, etc)


Briefly speaking, sort positive values highest to lowest and negative values lowest to highest in the same column and delete rows with 0 values.


Looking for some help

Hello Maxal,

This macro will sort and delete the rows on the Activesheet of the ActiveWorkbook.

Please Login or Register  to view this content.