Linking formulas

[Guest]

I have a workbook that has a worksheet for each customer showing all of their
outstanding invoices and whether they are 1-30 days, 31-60 days, 61-90 days
and over 90 days. Then I have another workbook where the customers names are
all listed and then the totals are linked to that sheet. The problem is that
when a customer pays an invoice, I go in and delete that row moving the row
that shows the totals and then in turn does not show the correct link on the
total worksheet that I have. any ideas on how I can fix that?

 

[Fred Smith]

Yes, it can be fixed. It would be a lot easier if you gave us the formulas you
are using.

Do you use Vlookup to find the customer? Are you using Sumif to get the total by
customer?

Let us know what the formulas are, and someone will be able to help you on it.

 

[Guest]

No - in the workbook that is separated by customers, I am using the
conditional sum method to calculate the aging totals. Then in the workbook
with all the customers with just the totals, I am simply copying the total
from the individual customer to the column in the total column for the
specific customer and pasting, then clicking to link the cells. Does that
make sense?

 

[Guest]

Hi,

Excel -- Data Validation -- Create Dependent Lists.

Use this URL: http://www.contextures.com/xlDataVal02.html

Challa Prabhu