Linking excel workbooks
 

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

Linking excel workbooks
 

Create named ranges out of the totals and reference those named ranges, not
the cell address. Here's some info on named ranges:
http://www.cpearson.com/excel/named.htm

Dave
--
Brevity is the soul of wit.


"Shelly" wrote:

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

Linking excel workbooks
 

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


"Dave F" wrote:

Create named ranges out of the totals and reference those named ranges, not
the cell address. Here's some info on named ranges:
http://www.cpearson.com/excel/named.htm

Dave
--
Brevity is the soul of wit.


"Shelly" wrote:

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

Linking excel workbooks
 

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
--
Brevity is the soul of wit.


"Shelly" wrote:

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


"Dave F" wrote:

Create named ranges out of the totals and reference those named ranges, not
the cell address. Here's some info on named ranges:
http://www.cpearson.com/excel/named.htm

Dave
--
Brevity is the soul of wit.


"Shelly" wrote:

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

Linking excel workbooks
 

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


"Dave F" wrote:

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
--
Brevity is the soul of wit.


"Shelly" wrote:

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


"Dave F" wrote:

Create named ranges out of the totals and reference those named ranges, not
the cell address. Here's some info on named ranges:
http://www.cpearson.com/excel/named.htm

Dave
--
Brevity is the soul of wit.


"Shelly" wrote:

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