How to Copy Row to an Empty Row on Column Change ?

Hi guys I ‘ve tryed to make an code to auto copy columns informations to a new row above the one without luck .. can someone give me a light ?

Here is the my excel project structure:

A1 = Client
A2 = Date
A3 = Status

A1 = Test | A2 = 03/23/11 | Status = (Done, Waiting)
if user selects waiting all the data should be copied to another row just the date field has to be changed to the next day something like this:
A1 = Test | A2 = 03/24/11 | Status

Any tips ?

Regards
Diego.