Kisha

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!

rick_deacha

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...

NateBrei

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

Kisha

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

rick_deacha

Let see if this helps you

Kisha

It's excatly that what i wanted!
Thx!