• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add date time stamp when values change in row

Wmickle

New Member
Looking for code to add date time stamp when information changes in a row. My data file consists of 26 columns of information.
 
Looking for code to add date time stamp when information changes in a row. My data file consists of 26 columns of information.

Turn on change tracking for a workbook
Be certain that you want to use this method before continuing. Shared Workbooks have limitations, and one in particular is the inability to edit using Excel for the web. Therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.
  1. Click Review > Share Workbook.
    Note that in newer versions of Excel, the Share Workbook button has been hidden. Here's how to unhide it.
  2. In the Share Workbook dialog box, on the Editing tab, select the Allow changes by more than one user at the same time check box.
  3. Click the Advanced tab.
  4. Under Track changes, click Keep change history for and, in the days box, type the number of days of change history that you want to keep. By default, Excel keeps the change history for 30 days and permanently erases any change history that is older than this number of days. To keep change history for a longer than 30 days, enter a number that is larger than 30.
  5. Click OK and, if you are prompted to save the workbook, click OK to save the workbook.
 
Wmickle
One possible code ... from Your given details.
> do some changes to this sheet
 

Attachments

  • Wmickle.xlsb
    13.3 KB · Views: 3
Back
Top