A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

copying formulas with fill handle



 
 
Thread Tools Display Modes
  #1  
Old March 30th, 2010, 01:39 PM posted to microsoft.public.excel.newusers
Bob L[_2_]
external usenet poster
 
Posts: 9
Default 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.

  #2  
Old March 30th, 2010, 02:56 PM posted to microsoft.public.excel.newusers
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default 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.

.

  #3  
Old March 30th, 2010, 03:21 PM posted to microsoft.public.excel.newusers
Bob L[_2_]
external usenet poster
 
Posts: 9
Default 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.

.

  #4  
Old March 30th, 2010, 03:55 PM posted to microsoft.public.excel.newusers
Bernard Liengme
external usenet poster
 
Posts: 516
Default 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.


  #5  
Old March 30th, 2010, 04:49 PM posted to microsoft.public.excel.newusers
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default 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.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.