Copying a row to a column with formulas involved.

[Heather]

I have a row that contains formulas, basicly the sum of a
column. I want to copy the results (a row's worth) to a
column on a different page. This way if the sum changes
from the first worksheet, it will be reflected in the
second worksheet column. I've tried to transpose it,
under special paste, but it does not seem to keep the
formulas correct. Any suggestions?

Thanks,

Heather

 

[Frank Kabel]

Hi
if your source data is in sheet 1, cells A10:F10 try the following in
cell A1 on your second sheet:
=OFFSET('sheet1'!$A$1,COLUMN(A-A)-1,0)
and copy this to the right

 

[RagDyer]

Say your formulas are adding Rows 1 to 25, and your Sum formulas are in
Row26, from Column A to J on Sheet1.

Enter this formula in A1 of Sheet2, and drag down to copy to A10:

=OFFSET(Sheet1!$A$26,,ROW()-1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a row that contains formulas, basicly the sum of a
column. I want to copy the results (a row's worth) to a
column on a different page. This way if the sum changes
from the first worksheet, it will be reflected in the
second worksheet column. I've tried to transpose it,
under special paste, but it does not seem to keep the
formulas correct. Any suggestions?

Thanks,

Heather