L
Legacy 286866
Guest
Hi All,
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).
Any good ideas how to do this? (Shared from my Google Photos)
https://goo.gl/photos/cMpUmDHtZw9wGbyz6
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).
Any good ideas how to do this? (Shared from my Google Photos)
https://goo.gl/photos/cMpUmDHtZw9wGbyz6
