View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shelly Shelly is offline
external usenet poster
 
Posts: 84
Default Linking formulas

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