I tried that and all it did was give me zeros in B11 through B13

"trip_to_tokyo" wrote in message
...
EXCEL 2007

1. Highlight cells B 66 to D 66 in your first spreadsheet.

2. Ctrl-C to copy.

3. Go to next Worksheet and click in cell B11 then Home tab / Clipboard
group / Paste / Paste Special – in here select Values in Paste group (at
top)
and Transpose (lower right hand corner) / OK.

Your totals will now be pulled in from the first Worksheet into cells B11
to
B13.

If my comments have helped please hit Yes.

Thanks.



"Bob L" wrote:

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.

.