Urgent Help -- Macro Code to insert new row and coy formula

[Mysore]

Hi Guys,

Need of a macro code to Insert a new row and copy data from above row only if it has formulas.

Any help is here much appreciated.


Thanks

Mysore

[JBeaucaire]

Excel's TABLE function does this for you without the need of a macro. Click inside your table and press CTRL-L to start the TABLE/LIST wizard, let it convert your data to a table.

Now, when you click inside the table, an "expansion row" is offered to you below the table. IF you type into ANY cell in that row, the row will expand to permanently become a part of the TABLE and all formulas and formatting are copied instantly from the row above, just like you want.

Try that.

[Mysore]

Thanks heaps. Really helped.

Cheers

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.