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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|