I am trying to create a form where people can use the same workbook on a
network at the same time and input data into different parts of the
worksheet. If several people have the workbook open and one person goes to
save, and the second person behind him to save put information into the same
cell, the changes from the other user should be put in a new row below the
original one.
I tried the protect and share and allow multiple users, it works when I have
a simple worksheet, but when I put in the different areas for people to put
in data, it will no longer add the changes onto the original one, it will ask
to accept your changes, or the other persons changes and will replace the
data instead of adding it into a new row.