Linking excel workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some advise. I have a workbook set up with all of our customers have
an individual statement showing their outstanding balance. I want to link
this information to a general aging report showing each customers total due,
30 day, 60 days, etc. I have tried to just link the total on the statement
to the line in the aging report, but I often add and delete rows in the
statement and this keeps changed the cell where the formula that calculates
the totals are. Any suggestions to make the aging report still show the
totals no matter what cell they appear in on the statement?
 
Will this work if the formulas used to create the totals were used based on
the conditional sum formula?
 
I'm not sure what you mean by a conditional sum formula, but if you create a
named range and then use that named range in any formula, the formula will
still work....

Dave
 
Dave,

I am sorry - I am just confused. I have not worked much with names ranges
or cells. Do you have to define the name in both the destination and the
source workbook?
 
Back
Top