Took over a report from a former employee and it looks like it was a pivot table? 

We used to be able to just dump last year cancels and it would add it to the main sheet. I have tried to do my general troubleshooting. ( making sure that the formulas was on automatic not on manual etc)

We just want to be able to dump the data from last year cancels to this year and see if we wet met our retention goal instead of manually counting. 

any help or advise is greatly appreciated!

​Took over a report from a former employee and it looks like it was a pivot table?  We used to be able to just dump last year cancels and it would add it to the main sheet. I have tried to do my general troubleshooting. ( making sure that the formulas was on automatic not on manual etc) We just want to be able to dump the data from last year cancels to this year and see if we wet met our retention goal instead of manually counting.  any help or advise is greatly appreciated!   Read More

​