Trying to get external data from another sheet. When I use the filter options, I would like to reference a cell in my worksheet for the value data. (e.g. Month or Day). Excel will continue with the query and seemingly work, but only partial data is showing. Any ideas?

<img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>