abraham30
03-07-2013, 10:59 AM
Hello Everyone
I want to print the data of HCP sheet into both pdf and document format.
I manage somewhat for pdf. Can anyone help me how can it be possible
Please note that the pivot table is auto-refreshed (both row and column are in variable range) and also the title border(fill color) is changing continuously
Details:--
PrintArea---row and column with variable range
PrintTitleRows---$1:$10
CenterFooter = &P/&N
Advance thanks for your support
I want to print the data of HCP sheet into both pdf and document format.
I manage somewhat for pdf. Can anyone help me how can it be possible
Please note that the pivot table is auto-refreshed (both row and column are in variable range) and also the title border(fill color) is changing continuously
Details:--
PrintArea---row and column with variable range
PrintTitleRows---$1:$10
CenterFooter = &P/&N
Advance thanks for your support