I have an excel sheet with IDs beside cases. When I work the case and get a reply I want the excel spreadsheet to work out its the same case and update the original without adding a new case onto the sheet.

I have attached a screenshot to show a really rough example, A reply has come in for ID 2 and 3 as ID 4 and 5 but I would link the reply to replace the data in ID 2 and 3 and erase the data in the Reply field (keep the data in the other fields).

Unsure how to do this. I know what I want to do but still learning excel stuff so any recommendations would be helpful.

Unsure if this has been posted in the correct section on here, if not please let me know ^_^

Have also attached a screen shot from my Google drive. Tried using the picture uploader but does not seem to be working.

https://goo.gl/photos/cMpUmDHtZw9wGbyz6