I need a macro that will:
If cell in column A is not blank. (Column A,B,C and D will contain data)
Then copy contents of that cell in column A and then insert entire row then
copy to the new row and delete original cell. I will need a loop till done.
Thanks for any help on this macro.