Hello All,
I saw several posts that were almost what I needed, but not quite. So I thought I would throw my problem out there.
I have a large macro-enabled workbook which I am trying to make more easily reviewed as there are multiple users. Two worksheets in particular have heavy user input.
What I am looking for is two columns, one that will automatically generate a time/date stamp and another that would record last user. Both of these triggered by editing cells in that row in columns C,J,L,M,N,O. So if any of these columns are edited in a given row, one cell would record the last edit time, and the other the last editor (user name).
Thanks for your help in advance!
I saw several posts that were almost what I needed, but not quite. So I thought I would throw my problem out there.
I have a large macro-enabled workbook which I am trying to make more easily reviewed as there are multiple users. Two worksheets in particular have heavy user input.
What I am looking for is two columns, one that will automatically generate a time/date stamp and another that would record last user. Both of these triggered by editing cells in that row in columns C,J,L,M,N,O. So if any of these columns are edited in a given row, one cell would record the last edit time, and the other the last editor (user name).
Thanks for your help in advance!