Drop downs & filters

Hi,

First post so please excuse me if this has been covered before but I am trying to get the results of a dropdown menu in one worksheet to become the criteria for a filter in another worksheet (both in teh same workbook).

I thought I could just add a reference to the dropdown cell into the autofilter (in VBA editor) but it doesn't seem to be that simple.

Any ideas?

Thanks for the help.

Something like this

Please Login or Register  to view this content.

Have you got a Field 3 in your workbook/ Try attaching the workbook

It would be easier to see the workbook.

Is is picking p the criteria correctly?

You can use the worksheet change event to trigger he code. Like this

Please Login or Register  to view this content.

To add this code to your worksheet, do the following:

Copy the code above
Select Frontsheet's tab
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste

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