I have a table (let's call it report) that I populate using the SUMIF function. Basically it looks for data of a certain type and sums it. The data is on another worksheet in the same workbook.
What happens is that every month I will copy the report table to another worksheet for historical reference. I then delete the 'data' table. What happens is that I will get #REF! errors on all my SUMIF functions. I have to go through the pain of resetting all of them.
An example of one of the codes I use is
How do I keep the function from getting these errors and having to fix them each time?