Forum Discussion
Sam_Chig
Nov 05, 2021Copper Contributor
Update date when a certain cell is changed
I want the current date to be updated when I change the Attempt # column. Date is column G and Attempt # is column I. To be clear, when I change attempt # in a cell, I want the Date Called corre...
Sam_Chig
Nov 05, 2021Copper Contributor
Thank you!! There is an issue though.
It gives me "argument not optional"
It gives me "argument not optional"
HansVogelaar
Nov 05, 2021MVP
Strange - it works for me. See the attached sample workbook.
- Sam_ChigNov 08, 2021Copper ContributorInteresting. I'm using excel through my company, but macros are enabled. The data is also in a table if that means anything. I'm not sure where the issue is.
- HansVogelaarNov 08, 2021MVP
Could you attach a copy of the problem workbook, without sensitive information?
- Sam_ChigNov 08, 2021Copper Contributor