Maybe you could give us some more details on
a) what the data in A looks like
b) where new data goes each day
c) what formulas you have in B that attempt to reference the new data
in A

It might be possible to devise formulas for B that survive changes in
the data in A. Otherwise I would suggest a macro to update B.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup