Frank Bacchus
Member
Hi All:
I would like to change the value of a cell only if a switch is set to ‘1’. I have two cells with dates in my sheet in column A and column B and I would like to perform 3 sequential steps:
(1) Change the format of both Columns A and Column B from mm-dd-yyyy hh:mm:sec to mm-dd-yyyy
(2) If the records in Column B exist in Column A, and the dates are different, make the dates the same using the value in Column B. If not, leave ‘as is’.
This can be a Macro with I can run myself. Thanks and I appreciate your assistance.
I would like to change the value of a cell only if a switch is set to ‘1’. I have two cells with dates in my sheet in column A and column B and I would like to perform 3 sequential steps:
(1) Change the format of both Columns A and Column B from mm-dd-yyyy hh:mm:sec to mm-dd-yyyy
(2) If the records in Column B exist in Column A, and the dates are different, make the dates the same using the value in Column B. If not, leave ‘as is’.
This can be a Macro with I can run myself. Thanks and I appreciate your assistance.