Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter
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. -- Gary''s Student - gsnu200758 "KrisP" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |