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