Lets say in a1 i have a drop down list that contains the values 1-12.
and in a4:l112 i have a table. the columns we want to look at it is the "Order_Dates"
i want to know how to filter this column using cell A1.
would like it to basically check what number in in cell a1 and filter ftemp.xlsxor that month in the order dates column....been looking for ideas but not been able to find...can anyone help?
i am attaching the file...please help
Bookmarks