Macro for inserting lines with Text
 

HI

Need to do a marcro that when I insert a new row it automatically inserts 7
new rows each containing text in column which represents what is in the
corresponding columns.

The only problem i kept running into is that if I already had a number of
records anytime i tried to insert a new line into two existing records it
always ran into the second section, pasting over existing text and figures
which I need to avoid.