View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AndrewEdmunds AndrewEdmunds is offline
external usenet poster
 
Posts: 20
Default Rolling Forward Pivot Table Source Data

Hello,

I am using a pivot table to consolidate the financial statements of 26
facilities. How do I roll forward the pivot tables to point at the next
month's facility files without having to recreate a new pivot table each
month?

Thanks
--
Thank You
Andrew Edmunds