put name, date in the cell byitself

[amna77]

Hi , i want to place user name and current date and time in the cells.
its row by row, if i enter date in A1, B1, J1 then it should put the persons names, date and current time in cells K1,L1,M1.


Thanks in advance

 

[SkipVought]

amna77,

In K1
[tt]
=A1
[/tt]
In L1
[tt]
=B1
[/tt]
In M1
[tt]
=J1
[/tt]



Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[amna77]

no sorry my mistake its data not date, "if i enter data in A1, B1, J1 then it should put the persons names, date and current time in cells K1,L1,M1." When ever i enter someting in a1:H1, then its sgould put date and time in one cell K1, L1, M1
and if i enter date in a2:h2, then its should put persons name and data and time in the cell k2, l2, m2

anybody know how to do that. i need to put vb codes in the back on change event, but don't know how exatly tp write. any help?
thanks

 

[SkipVought]

This is the MS Office Forum.

If you want a VBA solution, please post in the VBA Visual Basic for Applications (Microsoft) forum707.



Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}