VBA: Copying All formats and formulas to a next row

[inddon]

Hello There,

I have 15 columns with formats, conditional formatting and formulas in various columns. The first column and row starts from B6 (Serial Number). Column B7 has the formula as: IF(ISBLANK($C6),"",$B6+1). Attached jpg file is the snapshot of the data.

What I would like to do is the following:
1. When the user comes to a new row, the serial number gets generated.
2. The user enters the Invoice Number, and when he leaves the column Invoice Number, it should copy all the formats, conditional formats, and formulas from current row to the next row (attached file for example from row 8 into row 9)

Could you please guide and advice, how this could be achieved in VBA?

Thank you.

Looking forward to hearing from you.


Greetings
Don

 

[Luke M]

I would recommend setting up an XL Table/List to hold your data. You can apply formatting to table columns, and it will auto-extend as you add more data. Formulas will also be copied down.
Into to tables:
http://chandoo.org/wp/2009/09/10/data-tables/

 

[inddon]

I would recommend setting up an XL Table/List to hold your data. You can apply formatting to table columns, and it will auto-extend as you add more data. Formulas will also be copied down.
Into to tables:
http://chandoo.org/wp/2009/09/10/data-tables/

Thank you Luke