csriram45
Well-known member
turbo2ltr,
Sent you an email and PM not sure if you got them. I went ahead and created a form that members can submit for changes and it would go into a sheet similar to the original with a timestamp. All then you would need to do is sort my a member and then copy the row with the latest time stamp for each member and paste it over the original. Once done you can delete the all the rows for each member as a result when you are done with the updates the the spreadsheet output of form would be empty everyday and ready to take more entries for future updates.
Give it a try and let me know if you think it works as intended then we can open up the form to the members.
Sent you an email and PM not sure if you got them. I went ahead and created a form that members can submit for changes and it would go into a sheet similar to the original with a timestamp. All then you would need to do is sort my a member and then copy the row with the latest time stamp for each member and paste it over the original. Once done you can delete the all the rows for each member as a result when you are done with the updates the the spreadsheet output of form would be empty everyday and ready to take more entries for future updates.
Give it a try and let me know if you think it works as intended then we can open up the form to the members.