copying 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.

copying formulas with fill handle
 

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.

.

copying formulas with fill handle
 

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.

.

copying formulas with fill handle
 

See answer in workfunction newsgroup
No need to multi-post
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.

copying formulas with fill handle
 

Hi Bob, I did test that it worked before I posted and it did work.

I have just re-tested, on another Workbook, and repeated the process that I
have outlined, and it does work.

Maybe you have clicked something wrong somewhere along the way?

Perhaps worth another try?



"Bob L" wrote:

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.

.