i have created a dashboard that is shared by multiple users. i have a spreedsheet that my coworkers are sopposed to update on a weekly basis. Unfortunatly i have to add something to keep them honest.
is there a way to embed a macro that will timestamp the last time a row was modified and put the timestamp in a hidden cell with white text so only i know its there. also if possible i would like it to tell me who last modified it ...all users are identified by the network.
the rows i want to record are 5-9 columns b-j and i want to hide the results in column n
is there a way to embed a macro that will timestamp the last time a row was modified and put the timestamp in a hidden cell with white text so only i know its there. also if possible i would like it to tell me who last modified it ...all users are identified by the network.
the rows i want to record are 5-9 columns b-j and i want to hide the results in column n
