copy formulas with fill handle

[Bob L]

I have two spreadsheets and want to link info from one sheet to another. I
have totals at the bottom of columns and I want to be able to put those
totals into another spreadsheet. I want to do this with the fill handle
instead of entering one by one.

I have totals in lets say B66,C66,D66 and so on. I want to be able to put
those numbers in the next spreadsheet in cells B11,B12,B13 and so on. B11
should equal B66 , B12 should equal C66 and so on.

Any help would be appreciated.

 

[Bernard Liengme]

In B11 of Sheet2 enter =OFFSET(Sheet1!$B$66,0,ROW(A1)-1)
This will evaluate to =OFFSET(Sheet1!$B$66,0,0) and will be the same as
=Sheet1!B66
Drag the formula down the column
In B12 you will have =OFFSET(Sheet1!$BA$661,0,ROW(A2)-1)
This will evaluate to =OFFSET(Sheet1!$B$66,0,1) and will be the same as
=Sheet1!C66
etc
best wishes

 

[Bob L]

That worked great. Thanks

In B11 of Sheet2 enter =OFFSET(Sheet1!$B$66,0,ROW(A1)-1)
This will evaluate to =OFFSET(Sheet1!$B$66,0,0) and will be the same as
=Sheet1!B66
Drag the formula down the column
In B12 you will have =OFFSET(Sheet1!$BA$661,0,ROW(A2)-1)
This will evaluate to =OFFSET(Sheet1!$B$66,0,1) and will be the same as
=Sheet1!C66
etc
best wishes

 

[T. Valko]

Another one...

Entered in Sheet1 B11 and copied down as needed...

=INDEX(Sheet2!B$66:J$66,ROWS(B$11:B11))

Adjust for the correct end of range J$66.

 

[bob]

Thanks Biff, this worked great

Another one...

Entered in Sheet1 B11 and copied down as needed...

=INDEX(Sheet2!B$66:J$66,ROWS(B$11:B11))

Adjust for the correct end of range J$66.

 

[T. Valko]

You're welcome. Thanks for the feedback!