Hello everyone
i have a workbook with around 50 pivot tables
i have a field with sales date
is it possible to use a macro to select a specific date range
example: in cell A1 and A2 put 01/06/2011 and 25/06/2011
and run the macro to choose these sales dates only?for all pivot tables?
(i actually need to do it in once and then dublicate it for the rest,i think)
thanks in advance!
i have a workbook with around 50 pivot tables
i have a field with sales date
is it possible to use a macro to select a specific date range
example: in cell A1 and A2 put 01/06/2011 and 25/06/2011
and run the macro to choose these sales dates only?for all pivot tables?
(i actually need to do it in once and then dublicate it for the rest,i think)
thanks in advance!