Hi Guys,
I'm trying to find a way for Excel to automatically insert the username & date when a row if filled out or updated.
The spreadsheet will be eventually saved on OneDrive.
Please see the test file.
Thanks,
Kapi
Hi Guys,
I'm trying to find a way for Excel to automatically insert the username & date when a row if filled out or updated.
The spreadsheet will be eventually saved on OneDrive.
Please see the test file.
Thanks,
Kapi
Last edited by kapi98; 01-22-2023 at 04:29 PM.
See code in the worksheet module. Adds/updates date and Windows login username each time anything is changed on a row. Works if multiple rows are updated at once (e.g., paste).
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thanks, is there a way we can restrict this code to a certain range?
I tried this modification but it's not going well.
Please Login or Register to view this content.
Like so:
Please Login or Register to view this content.
Awesome, thanks for your help.
Would it be possible to delete this digital signature when the user deletes data from this row?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks