Defining Print Ranges From Pivot Tables

T

TP

I have a Excel Spreadsheet that contains 3 workbooks, two of which
contain data, one of which contains data which my pivot table on the
third workbook feeds off.
When in the pivot table i have added 4 four more columns of
calculations on the right hand side of the pivot table. These columns
use data from the pivot table and the data sheet to perform the
calculations. As the amount of data changes variably on what is
selected from a field within the pivot table i have had to use iserror
and isna formulas so when there is only a short table the colums to
the right return blanks rather than error messages.

Is there a way that i can create a macro that will look for the bottom
right hand corner of the data and set the print range to this area
automatically.

Also is there a way that i can use a list on a different sheet to
alter data on my pivot table. eg pivot table field contains options
1,2,5,77,88,45,
My list on the other sheet contains also this data and if selected it
would change the relevant field on the pivot table.

Thank you for any help
 
Top