How can I Get Transactions to Populate after Recovering a Copy from the Past?

I am using transactions sheet to populate then it goes to a Pivot table. My problem is: I recovered a copy of the worksheet from a month ago. But the “Description” does not populate it says


when I try to change the Description. I says invalid. I went to the transaction page because it is not populating precedes the pivot table.

I gather the formula is wrong, but not sure how to make it right.

I think I understand what you are trying to do. Perhaps you can create a new test sheet and manually copy/paste the correct descriptions from the test sheet into your current sheet.

Thank you, that is what I did and I think it worked.