Macro to sort data in descending order

Is it possible to sort two different ranges of data on seperate tabs in descending order using a macro?

I would like sort data in both tabs by order of volume while keeping all data in tact. Also I do not want to include the header or "total" row in the sort.

Please refer to the .xls file for reference.

Thanks!

Hi Vbort44,

As long as the data consistently starts at cell A2 for both Sheets and the Volume Columns for Sheet1 and Sheet2 are B and D respectively, the following will do the job:

Please Login or Register  to view this content.

HTH

Robert

Originally Posted by Trebor76

Hi Vbort44,

As long as the data consistently starts at cell A2 for both Sheets and the Volume Columns for Sheet1 and Sheet2 are B and D respectively, the following will do the job:

Please Login or Register  to view this content.

HTH

Robert

Perfect! Many thanks!