Don't give up so soon...
Have a look at the sample attached (make sure you activate macros on opening)
if you do not want to insert a new row at every row, delete the line from code with the expression entirerow.insert..

Attached Files

test.xlsm (18.6 KB, 9 views)