I want the date and time to automatically populate when I enter something into cell C5
I want the Date to auto update in C6
and the time to auto update in C7 as soon as i enter something into C5
Is there a formula for this?
I tried to copy and paste that to the work sheet after clicking veiw code. But when I enter values in cell c5, c6 and c7 do not change and a pop up appears that says end or debug I've tried both but cnnot figure it out.