I have a problem that I cannot solve.

No Date Time Method Name Question



What I need is when a Method is selected in cell D,
I would like the Now() function to activate in Date (cell B)
and also the Now() funtion to activate in Time (Cell C)
(I am using the Now() function to grab the system date but if there is a better function please suggest that.

I want to stop these cells from updating when I move down the spreadsheet.
At the moment they dynamically update which I do not want.

Is this possible?

Thanks you guys you really rock.
Thanks for past help.