Linking excel workbooks

S

Shelly

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?
 
S

Shelly

Will this work if the formulas used to create the totals were used based on
the conditional sum formula?
 
D

Dave F

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
 
S

Shelly

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top