I have a macro that inserts a row and then inserts data for six columns.

I need to get the macro to insert data for all rows that have data in the columns.

I figured that the macro would look something like this

'Sub

'Insert Row

'Loop as long as there is data in the row above

'Macro runs

"end Loop

End Sub

Any ideas how to do this