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.