Filter

[KrisP]

How do I filter the contents of a table using one cell. I dont want to use
auto filter as I only want the user to be able to filter on one column. I'll
explain, I have a table with months in. Following the months are lots of
other info. In cell A1 I want the user to choose one month from a single cell
and futher down in the workbook I want that month to appear. Is this
possible? Sorry if i have explained myself very well

 

[Gary''s Student]

There is a little trick:

If you click on a header cell, say C1, and apply autofilter, the filter is
available across the entrie first row.

Instead, click on column C, apply AutoFilter, and AutoFilter will only be
available on that column.