Hi every,

How are you all,

i was facing the problem, in XL i have 2 sheet name sheet1 and sheet2,

IN SHEET1 COLUMNA1 I HAVE PEOPLES NAME LIKE JOHN,SEENA,ROCK LIKE THIS
WITH VALIDATION LIST(COLUMNA1), COLUMNB1 FORMULA IS THERE =now
formula HAS CONSIDER AS TIME AND DATE, IN COLUMNA1 PEOPLE HAVE HIS/HER
have SELECT THE NAME LIKE SEENA , ROCK, ONCE SELECT THE NAME CLICK
COMMAND BUTTON (SAVE) I NEED TO PASTE SPECIAL IN SHEET2 COLUMNA1
NAME(ROCK) COLUMNB1 TIME , ONCE SEENA GOING TO BE SELECT ABOVE
PROCEDURE WILL AUTOMATICALLY PASTE SPECIAL IN COLUMNA2& COLUMNB2 MEAN
ITS NEVER GOING TO BE AFFECT THE PREVIOUS RECORD.EXCEL AUTOMATICALLY
SAVE CLOSE

EG:
RESULT I NEED LIKE IN (SHEET2)

A B
1 ROCK 15/02/08 8:59AM

2 SEENA 15/02/08 9:00AM

3 JOHN 15/02/08 11:00AM

LIKE THIS I HAVE MORE THAN 50 PEOPLES,

KINDLY HELP ON THIS,

REGARDS