invalid reference...please help...asap

  • Thread starter Thread starter kraft
  • Start date Start date
K

kraft

I have 14 sheets in the workbook divided into two groups. the first
have data and the seventh contains formulas which summarizes the firs
6. Same goes with the other seven. The 6 sheets are daily reports and
was told that I should start on specific date which leaves only
sheets for the 1st group and move the 5th and 6th on the next group
2nd group will then have 8 but summary includes 6 days only so I delet
the last two sheets. Now the 2nd summary lost its reference and has tw
#refb5 on its formula. I was able to do FInd and replace on the firs
summary but not on the second because it has two #refb5. If I replac
one both will be replaced.
Does anyone has an idea how I can pull through with this?

thanks..
 
Back
Top