AutoFilter & Sort

Kisha
08-31-2004, 06:43 AM
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
08-31-2004, 08:39 AM
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
08-31-2004, 03:39 PM
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
09-01-2004, 01:22 AM
:cool: This Subtotal-Way could work. Thx!
As NateBrei considered, i would have to hide the row where i'd put the formula.

rick_deacha
09-01-2004, 08:26 AM
Let see if this helps you

Kisha
09-03-2004, 01:16 AM
It's excatly that what i wanted!
Thx!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum