Cannot work out the debug with copying static date

[unley]

I'm trying to create vehicle maintenance inspection program for a mechanic at work. The trouble is the he's not fond of computer and I'm trying to make it as simple as possible.
There's a debug in the line

Please Login or Register  to view this content.

in

Please Login or Register  to view this content.

I've enclosed an attachment for you to see.
After double click on yellow cell in "Sheet6572", it should copy the range from above to next row down to make another inspection form and create a static date on right side of "Date" cell.
Then copy the date to "Service History" sheet in B11

Thanks in advan

[davesexcel]

Try this.

Please Login or Register  to view this content.

[unley]

Yep davesexcel, that works great, gee I wish I know VBA as much as you with such confident.
Thank you very much for this and will add your reputation for this, cheers