I have been asked to keep a document up to date. I am given a document with
the information going across from columns A through BD. This obviously
cannot be printed on one page. I would like to have another document with
the information going down in rows, so that I can print in portrait on one
sheet. How can I link these two documents?
Any help is appreciated.
Sue
Depending on how often you wanted to print, it might be easier to select the data (A1:BD15 etc) and Copy, then on a new sheet Paste Special - Values, Transpose.
(you may need to paste the formats (transpose) first.
otherwise you could put in A1
=OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)
or better still:
=IF(OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)="","",OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1))
and formula-drag that down 56 rows, then across for some columns
Hope this helps
Originally Posted by SuzyQ
Last edited by Bryan Hessey; 11-02-2005 at 02:47 AM.
Hi Sue,
I would copy the entire table and paste it using "paste special" under the
EDIT menu. Select the "transpose" tick box and click OK.
I hope this helps.
Nicole
"SuzyQ" wrote:
> I have been asked to keep a document up to date. I am given a document with
> the information going across from columns A through BD. This obviously
> cannot be printed on one page. I would like to have another document with
> the information going down in rows, so that I can print in portrait on one
> sheet. How can I link these two documents?
> Any help is appreciated.
> Sue
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks