copy formulas with fill handle
 

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.

copy formulas with fill handle
 

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"Bob L" wrote in message
...
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.

copy formulas with fill handle
 

That worked great. Thanks

"Bernard Liengme" wrote in message
...
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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"Bob L" wrote in message
...
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.

copy formulas with fill handle
 

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.

--
Biff
Microsoft Excel MVP


"Bob L" wrote in message
...
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.

copy formulas with fill handle
 

Thanks Biff, this worked great
"T. Valko" wrote in message
...
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.

--
Biff
Microsoft Excel MVP


"Bob L" wrote in message
...
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.

copy formulas with fill handle
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"bob" wrote in message
...
Thanks Biff, this worked great
"T. Valko" wrote in message
...
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.

--
Biff
Microsoft Excel MVP


"Bob L" wrote in message
...
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.