How to auto sort on 1 sheet but for three different areas

Is there a way to auto sort on one sheet but sort three different areas within themselves. Attached the sheet but didn't send the hole workbook. Will attach workbook if needed.

You could use Column A as a column to find the highest value, then use vlookup to get the vehicle with the highest value

Hello,

assuming that you want VBA to do this, you can define and sort three different ranges one after another.

Put this in the sheet module

Please Login or Register  to view this content.