ExcelBanter - Find and replace in new row

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Find and replace in new row (https://www.excelbanter.com/excel-programming/423701-find-replace-new-row.html)

Stanley Braverman

Find and replace in new row

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.

All times are GMT +1. The time now is 01:34 AM.