Hello all, need a little help completing a macro that performs the following function within a row:
If the value in the Col marked “Output Effective Date” in the header is greater than the Col marked “Start Date” but less than the Col marked “End Date”, then replace the value in Col marked “Start Date” with the value in Col marked “Output Effective Date.” Something like this:
IF(value of “Output Effective Date” is GREATER THAN value of “Start Date” AND LESS THAN value of “End Date”) THEN value of “Start Date” is replaced with “Output Effective Date”
Would need this to loop through a full worksheet (several thousand rows). “Output Effective Date”, “Start Date” and “End Date” are not always in the same column, which is why I want to use the headers (row 1) as the variables in the equation.
Any help or guidance is most appreciated – thanks!
Bookmarks