Without knowing what the other sheet looks like it's hard to say. But, you
could use a worksheet_change event or perhaps even just a simple VLOOKUP
formula.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"muddan madhu" wrote in message
...
Hi,

I have excel sheet having 6 coulmns

Col A - Names
col B - Address
col C - Date
Col D - Login
Col E - Any changes in login
col F - Date of change in login

If the user changes the login time in col E... automatically only that
person's
details will reflect in other sheet.

I need macro to run this.. Is this possible ?