Brian Barker wrote:
At 15:26 17/01/2008 -0500, Victor Chapman wrote:
I may use the wrong terminology here, but.
I have workbook with several pages (tabs). What I would like to do is
to is to define a single print page using data from several of the
tabbed pages. In spite of my best efforts I can't figure out how to do
this.
I don't think it is possible to combine information from more than one
(tabbed) sheet of a spreadsheet on one page of printout, in fact.
(Perhaps someone will know better.)
The simplest way to do what you need is merely to copy all the
information you require into a region of one sheet - even, perhaps, an
extra sheet constructed for this purpose. When pasting into the area
you are going to print, use Edit | Paste Special... (or right-click |
Paste Special..., or Ctrl+Shift+V) instead of ordinary Paste, and then
tick Link under Options. This will mean that your new cells will have
references back to your source cells and will change when those cells
change.
Use Format | Print Ranges > | Define to restrict what you then need to
print.
I trust this helps.
Brian Barker
Thank you. I had discovered this work around. However, I was hoping that
there might be a more elegant solution!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
