Filter data on a sheet based on a drop down from another sheet

Hi,

On one sheet called "Control", I have two columns, one is "Area Size" and one is "Show?". Like this:

Area size Show?
0-19,999 Yes
20,000-39,999 Yes
40,000-59,999 Yes
60,000-79,999 Yes
80,000-99,999 Yes
100,000-119,999 Yes
120,000-139,999 Yes
140,000-159,999 Yes
160,000-179,999 Yes
180,000-199,999 Yes
200,000-219,999 Yes
220,000+ Yes


Depending on the text in column F (Show column), I want to autofilter data in a sheet called "Output". In output, I have 200 rows of data and a column D that contains the area grouping of each building. This is my current VBA code, however it is not working, and whenever I select Yes or No in the control sheet, it filters out all of the data as if none match the criteria, when I know it does.

Please Login or Register  to view this content.

Any idea as to why this isn't working?