[Excel]Shared Workbook and Conflict Resolution

I have a shared workbook that acts as a database. The problem is that when two users entered data into the same cell, a conflict will occur and an error message box will be promted, asking the user whose data to discard. I was wondering if it is possible to execute these action, only when the error msg box pops up.

Code:

---

ThisWorkbook.ConflictResolution = xlOtherSessionChanges
Worksheets("Data").Cells(Counter, 1).Value = AAA   
Worksheets("Data").Cells(Counter, 2).Value = BBB   
Worksheets("Data").Cells(Counter, 3).Value = CCC
Worksheets("Data").Cells(Counter, 4).Value = DDD
Worksheets("Data").Cells(Counter, 5).Value = EEE   
Worksheets("Data").Cells(Counter, 6).Value = FFF
Worksheets("Data").Cells(Counter, 7).Value = GGG
Work  Worksheets("Validation").Cells(2, 1).Value = Counter + 1

---

The main idea to accept the other users changes and have the local data moved into the next row