View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Start Date And End Date with pivot tables?

use the find command to find the start and end dates.

Then copy the records between these two locations to a new worksheet with
the header information. Then use this as the source for your pivot table.

--
Regards,
Tom Ogilvy


"Mark J" wrote:

how can i program thru vba a start and end date that will push these date
values into pivot table on code exececution?