Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How workbooks link to other workbooks
I have one workbook that new rows are added to when a new job is bid. I want
to link to a cell with the total that will be at the bottom. What will happen when a new row is added? I need it to stay on the total value. -- Greg |
#2
|
|||
|
|||
Are you needing to be linked to the same cell? or do you need the link to
stay with the column total it was initially linked to? "Greg" wrote: I have one workbook that new rows are added to when a new job is bid. I want to link to a cell with the total that will be at the bottom. What will happen when a new row is added? I need it to stay on the total value. -- Greg |
#3
|
|||
|
|||
Is that cell with the link on another worksheet in the same workbook?
If yes, then it'll work fine. If it's in a different workbook, then if both workbooks are open, it'll work fine. If the "receiving" workbook is closed, then you may have trouble. If you used something like: ='C:\my documents\excel\[book1.xls]Sheet4'!$A$24 as your link, then it won't work nicely. But if you name that cell (insert|Name), then your formula could look like: =book1.xls!myTotal_01 Then it'll work ok. === One thing you may want to consider. Put those totals in Row 1 (with headers in row 2). Then you won't have to worry about where they could be. And if you use window|freeze panes, those totals will always be visible when you're playing with your data--no need to scroll down to see the total. Greg wrote: I have one workbook that new rows are added to when a new job is bid. I want to link to a cell with the total that will be at the bottom. What will happen when a new row is added? I need it to stay on the total value. -- Greg -- Dave Peterson |
#4
|
|||
|
|||
I'm not sure what you mean. Say I have a sum function in H10 I add a row
above it so the total is now in H11. will my link in the other book update to H11 or do i have to reassign it? -- Greg "Anna" wrote: Are you needing to be linked to the same cell? or do you need the link to stay with the column total it was initially linked to? "Greg" wrote: I have one workbook that new rows are added to when a new job is bid. I want to link to a cell with the total that will be at the bottom. What will happen when a new row is added? I need it to stay on the total value. -- Greg |
#5
|
|||
|
|||
As long as you re-sum the column when you add the new row, the link should
update automatically. If you want a link to reference a static cell reference that won't change, you would put a $ sign in front of the row number and column letter (ex. $A$1) Hope this helps. "Greg" wrote: I'm not sure what you mean. Say I have a sum function in H10 I add a row above it so the total is now in H11. will my link in the other book update to H11 or do i have to reassign it? -- Greg "Anna" wrote: Are you needing to be linked to the same cell? or do you need the link to stay with the column total it was initially linked to? "Greg" wrote: I have one workbook that new rows are added to when a new job is bid. I want to link to a cell with the total that will be at the bottom. What will happen when a new row is added? I need it to stay on the total value. -- Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link two workbooks | Excel Discussion (Misc queries) | |||
Variable Link to Workbooks | Excel Worksheet Functions | |||
link two workbooks | Excel Discussion (Misc queries) | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
Link & Update Two Workbooks | Excel Worksheet Functions |