Dropdown and print area help

[suzette0735]

I have created a dropdown list to only show the rows I would like printed for each selection, but it seems I still have to change the print area. Is there a way to set print area dependent on the dropdown selection?

 

[sxhall]

Hi Suzette,

You can use the INDIRECT function in the'Name Manager' under the print area to make the rows variable (and/or columns as well)...

• In the below I choose an option from cell B3 for the area I want to print
• In cells D3 and E3 it looks up the the start and end rows from the table in columns H to J
• In the name manager I have used the below formula to return the start and end rows to the print area

=INDIRECT("Sheet1!$B$" & Sheet1!$D$3 & ":$B$" &Sheet1!$E$3 )

Downside is that If I change the print area columns from B:B to say D:D I have to change them in the name manager as it is hard keyed as B. You can use this method for the columns as well.

 

[suzette0735]

Hi Suzette,

You can use the INDIRECT function in the'Name Manager' under the print area to make the rows variable (and/or columns as well)...

• In the below I choose an option from cell B3 for the area I want to print
• In cells D3 and E3 it looks up the the start and end rows from the table in columns H to J
• In the name manager I have used the below formula to return the start and end rows to the print area

=INDIRECT("Sheet1!$B$" & Sheet1!$D$3 & ":$B$" &Sheet1!$E$3 )

Downside is that If I change the print area columns from B:B to say D:D I have to change them in the name manager as it is hard keyed as B. You can use this method for the columns as well.


View attachment 120404

Thank you! Can you break up the print area thought. IF i want to print for example, two different sections in one print :

A1-S41, A120-S121