rjplante
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 569
- Office Version
- 365
- Platform
- Windows
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)?