Is there a VB command that can copy the formats, formulas and Data Validation
from one cell into another cell.

I have a spreadsheet that I have created all the cell formats (bold, font,
Data Validation) in line 6.

If the user enters into a new line I would like to copy the structure of
line 6 to the new line they are entering on (same column).

Thanks
Hippy