Macro to insert row/fill cells

Hey all,

To simplify, i want to create a macro that would insert a row at a specified point and then fill down selected cells from the last row to the new cell.

Please See attached file,
Basically i want to insert a row after the 3rd submenu and the fill the contents of cell E7 into the new row in E8..
I would then assign this macro to a command button and i wanna be able to jus repeat the process if i clicked on the button

any help would be greatly appreciated.. thanks

Hi

Put your cursor in the place you want to insert the new row (say C8).

Associate this code with your button

Please Login or Register  to view this content.

This will insert the new row where the cursor is placed, and copy down the formula.

HTH

rylo