AutoFilter & Sort

Hello!

I have following Data in a Worksheet:

Price :: Status :: Item

When i filter the data via 'Item' i want that the data of 'Status' and 'Price' are sorted automatically.
Is there a way to do that automatic, or do i need an external event? (like the pushing of button?)

Thx in advance!

Well if you could have a Subtotal fórmula at the end of your data... then you could use the Worksheet_Calculate Event each time you do some filtering... then you could sort your Price and Status.

Let me know if this could be a posible way to solve your problem and then we could start coding...

If you put the formula at the end of the data, you could always hide the row (or change the font color to vbwhite) so that the formula isn't displayed. Everything would look like a normal list.

Nate

:cool: This Subtotal-Way could work. Thx!
As NateBrei considered, i would have to hide the row where i'd put the formula.

Let see if this helps you

It's excatly that what i wanted!
Thx!