I want to design a macro so as to do the following thing:
Insert a row.
Copy the value that is in a cell of the immediate before
row.
Copy this value in the row inserted.

I want the macro to repeat this in the whole workbook.

I know it is a simple one, but I can't figure it out
correctly.

Thanks a lot