Hi all,
I am trying to get a checklist done so I can determine when certain tasks are being completed each week. The current formula I have is =IF(B6="X",NOW()," "). This allows me to mark the task with an X and auto-populate the day and time the X was placed there. However, the date and time update every minute.
So I want to be able to say, Copy everything in Column C and Paste special Value in Column D. Then I will just Hide column C so that only the value is showing.
Is there a way to do this?
I am trying to get a checklist done so I can determine when certain tasks are being completed each week. The current formula I have is =IF(B6="X",NOW()," "). This allows me to mark the task with an X and auto-populate the day and time the X was placed there. However, the date and time update every minute.
So I want to be able to say, Copy everything in Column C and Paste special Value in Column D. Then I will just Hide column C so that only the value is showing.
Is there a way to do this?