I am trying to figure out a way to export my pivot tables to a standardized excel template with Headers and Footers - this will save me lots of time trying to manually do this...
Pivots are generally no bigger than 40 rows... we basically have a standardized Excel template, (.XLT) file that has all of our headers and footers on it, and we have 50 Pivot tables we want extracted to that template monthly to create 50 excel files.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.