Printing the last column on every page printed.

[Guest]

I want to be able to print the last column of my spreadsheet (Total column)
on every page that is printed from this workbook. How can I do this? I'm
stumped...

Thanks for your help!

 

[Dave Peterson]

Are all the last columns in the same location (column X for example)?

If yes, you could group all the sheets (click on the first, ctrl-click on
subsequent).
then select column X

File|print|Select (bottom left corner)

Do a preview first.

But this prints each worksheet (column) on a different sheet.

======
You could have a macro that built a new worksheet and just copy|pastes values|
that last column into consecutive columns (A, B, C for each worksheet). Then
print that. Heck you could even record a macro when you did it manually and
you'd be set.

======
You could create a new worksheet
then loop through each "total" worksheet and
select the column
Edit|copy
back to the new worksheet
Shift-Edit|paste picture link

And butt each picture next to the previous picture.

By pasting the picture as a link, these pictures will update when your
data/subtotals change.