| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy formulas with fill handle
In B11 of Sheet2 enter =OFFSET(Sheet1!$B$66,0,ROW(A1)-1)
This will evaluate to =OFFSET(Sheet1!$B$66,0,0) and will be the same as =Sheet1!B66 Drag the formula down the column In B12 you will have =OFFSET(Sheet1!$BA$661,0,ROW(A2)-1) This will evaluate to =OFFSET(Sheet1!$B$66,0,1) and will be the same as =Sheet1!C66 etc 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy formulas with fill handle
That worked great. Thanks
"Bernard Liengme" wrote in message ... In B11 of Sheet2 enter =OFFSET(Sheet1!$B$66,0,ROW(A1)-1) This will evaluate to =OFFSET(Sheet1!$B$66,0,0) and will be the same as =Sheet1!B66 Drag the formula down the column In B12 you will have =OFFSET(Sheet1!$BA$661,0,ROW(A2)-1) This will evaluate to =OFFSET(Sheet1!$B$66,0,1) and will be the same as =Sheet1!C66 etc 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy formulas with fill handle
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy formulas with fill handle
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copy formulas with fill handle
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "bob" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying formulas with fill handle | New Users to Excel | |||
| SET DEFAULT FOR FILL HANDLE TO COPY ONLY | Excel Discussion (Misc queries) | |||
| Help - copy a formula using the fill handle | Excel Discussion (Misc queries) | |||
| ROUNDUP copy/paste and fill handle not working | Excel Worksheet Functions | |||
| 3-d reference not adjusting when using Fill Handle to copy down | Excel Worksheet Functions | |||
![Bob L[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
