I have a few thousand excel files that need to be modified, one of the modifications is changing the value from Yes to No in column E based on value from column D.
For example, if value in D is: F13345C, or F13355C, or F13365C, and if the value in E is Yes, this Yes will need to be changed to No...