Advanced Formatting and Macro

[zarqa]

Hi,

I have completed doing an advanced filter however I am finding it difficult to do the second part. I want the Advanced filter to change when different Teams are picked on the drop down.

So automate the process when the user clicks on the drop down.

Thanks

[pike]

Hi zarqa
One way would be to use a worksheet event code in the sheet module

Please Login or Register  to view this content.

[zarqa]

Thanks ever so much!!

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save