Insert row with the previous data

Hi Everyone,

Is there any code which can automatically insert the row using the date from the previous row.

For EG

Date Ford Falcon Honda
29/10/12 100 106 99.1
29/11/12 103 107 111


Is there any way that I can click the text box and input box appears and ask to insert the row then copy ( 29/11/12 103 107 111 ) but only appears as (29/12/12 ) and ask to put the numbers in for ford, falcon & honda.

Thanks

Try using the macro recorder to record the selection and inserting of a row, and edit the code to suit the seated cell and date to copy.

You did not state the range location of the values, and if you are using a form with Textboxes etc....