track changes without using VBA

[rjplante]

I have a spreadsheet that has five columns in it Column A is for users to enter to do items. Columns D and E are for date entered, and last updated. I currently use a macro that uses the Worksheet_Change (ByVal Target As Range) feature to monitor changes to Column A in the worksheet and when data is first entered into a blank cell in column A, todays date gets entered into Column D. If Column A is edited on a later date, then the date is entered/updated in Column E. The problem I am having is that when I upload my spreadsheet onto Microsoft One Drive, and share it with all of the prospective users (10 people), none of the macros function. Is there a non macro way to achieve this (enter an updated date when changes are made in column A)?

 

[Bosquedeguate]

I have a spreadsheet that has five columns in it Column A is for users to enter to do items. Columns D and E are for date entered, and last updated. I currently use a macro that uses the Worksheet_Change (ByVal Target As Range) feature to monitor changes to Column A in the worksheet and when data is first entered into a blank cell in column A, todays date gets entered into Column D. If Column A is edited on a later date, then the date is entered/updated in Column E. The problem I am having is that when I upload my spreadsheet onto Microsoft One Drive, and share it with all of the prospective users (10 people), none of the macros function. Is there a non macro way to achieve this (enter an updated date when changes are made in column A)?

When you say the value in Column A is "updated" doing re-entering the same value constitute an update? even though the value did not change?

Are you other users aware that you have a macro-enabled Workbook? Excel gives a warning when you try to open a macro-enabled Workbook? Are they not allowed to do this?

 

[rjplante]

Changes would be only entries that result in a different value that what currently exists. The spreadsheet is shared on Microsoft One Drive. This allows users to edit the spreadsheet using the online web version of excel for data entry, which doesn't allow macros.

 

[Bosquedeguate]

Changes would be only entries that result in a different value that what currently exists. The spreadsheet is shared on Microsoft One Drive. This allows users to edit the spreadsheet using the online web version of excel for data entry, which doesn't allow macros.

Could a helper column be added? This is to avoid circular references. You need to be able to test the value of the cell you are updating (i.e. column D). I think the only way to do this without creating a circular reference is to write a value into another cell (column)

 

[rjplante]

Yes, a helper cell in another column would be possible.