If, for example you date is a row field in the pivot, right-click on the
heading for the date and select 'group and outline'. Enter the 'starting at'
date and 'finish at' date. The 'auto' checkboxes will be un-checked
automatically when you change these.

You pivot will now reflect only those dates

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"chance2motor" wrote in message
...
Is it possible to automate pivot tables???
I am trying to make an input page that will pivot information from my
sheet
of data inbetween certain dates specified on the input page instead of
having
to go and highlight the information for the pivot table.
Can anyone help with this??????