Hi there,
I have a spreadsheet that I manage where i have 10 admins working on it but only one of them is working at any time.
The problem i am having is that the consistency is not all there and often there are duplications of the work. in order to be able to eliminate the inconsistency and duplication, I need to be able to log the username of the admin and the time of the last changes they made to a specific row.
for eg: is x has made a change in row no 24, i need their username printed in column AB24. and the date and time to AC24.
Hope you can help with this.
thank you.
I have a spreadsheet that I manage where i have 10 admins working on it but only one of them is working at any time.
The problem i am having is that the consistency is not all there and often there are duplications of the work. in order to be able to eliminate the inconsistency and duplication, I need to be able to log the username of the admin and the time of the last changes they made to a specific row.
for eg: is x has made a change in row no 24, i need their username printed in column AB24. and the date and time to AC24.
Hope you can help with this.
thank you.