Automatic Date & Time VBA code

[Jagat Pavasia]

Dear Sir,

I want to auto date and time in format "dd/mm/yy hh:mm AM/PM"

My data is in from D7:J2500 and L7:M2500. (When I type in this column and Raws)

I want auto date in R7:X2500 and Y7:Z2500. (Auto Date Here)

For Example :
if I type in D7 then auto date and time in R7,
I type in E7 then auto date and time in S7
I type in L7 then auto date and time in Y7

send me VBA code, please

 

[mumps]

You are very welcome.