Copy values into other cells

[newbie2002]

Hi,

I have a spreadsheet and i must copy a value into other cells, how can i realise this. It seems like this:

col a | col b | col c
Mary
12-4-02
12:20
15:34
15:36
Check
Peter
13-4-02
16:32
17:43
18:56
Check

I must copy the dates and names in column a and b till the word "check" and then i must take the other date and copy and so on...It must be like this:

col a | col b | col c
Mary
12-4-02
Mary 12-4-02 12:20
Mary 12-4-02 15:34
Mary 12-4-02 15:36
Check
Peter
13-4-02
Mary 13-4-02 16:32
Mary 13-4-02 17:43
Mary 13-4-02 18:56
Check

I hope somebody can help i'm just a newbie in VBA...

 

[newbie2002]

Nobody helps