Hello, I have a spreadsheet with reporting data, in which each row has a unique case number/identifier. The report is missing an important field of who owns the account. Because the report changes—with new rows added and some removed each week— I can't just paste over the top.
When the new report is run, I want to update/override the data from the previous report, with the exception of my added column with the account owner's name. I'm hoping to find matching rows based on the unique case number and update the row if it still exists and if it doesn't, remove the row, as well as add any new rows from the most current report.
Apologies, I'm not great with Excel and don't know how to go about this and am looking for direction, in layman's terms.
I tried attaching a screenshot but it kept erroring out. Here it is: screenshot
When the new report is run, I want to update/override the data from the previous report, with the exception of my added column with the account owner's name. I'm hoping to find matching rows based on the unique case number and update the row if it still exists and if it doesn't, remove the row, as well as add any new rows from the most current report.
Apologies, I'm not great with Excel and don't know how to go about this and am looking for direction, in layman's terms.
I tried attaching a screenshot but it kept erroring out. Here it is: screenshot