date range for pivot
 

I need some code that accomplishes the following:

Have a cell that will be selected, and will indicate a week of the year (or
some date range indicator). I will convert that on the sheet using lookups
into two separate cells which are a start and end date. Based on these two
dates, I need a macro that will go to every pivot on my sheet and look at the
pivot's date field ("Date") and based on whether each item falls into that
range, select only those items to show.

Thx if anyone knows this. I know there is a way to evaluate all items (some
sort of "for all values in field" type of statement), but I don't know
exactly how to do it. Have seen it elsewhere.

--
Boris