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.

--
Regards,
Fred


"Shelly" wrote in message
...
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?
--
Shelly