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.