My question is regarding drop down list in excel. If i have data of all 12 month. and i have created a drop down list in excel of all 12 month (i.e. All, Jan, Feb, Mar... Dec..) and i want to show data through drop down list. if i will select Mar then only march data will show and the other data will not show.
Drop down list... (All, Jan, Feb....Dec)
Name Dept. Publisher Date Status ABC Production XXX 02/26/2011 Done
DEF Production XXX 02/02/2011 Done
GHI Production YYY 11/07/2011 Done
JKL Production ZZZ 03/07/2011 Done
MNO Production YYY 03/07/2011 Done
So in above example if i will section march in drop down list then only last two entry will be show... Is it possible on same location or on another sheet using formulas...