Hi Sean,

You want to move down column A looking for data in cells. Once found you
want to insert a row above the located data, then copy the data up to the
new
row, and finally delete the original row___

No. delete only old cell and copy only cell...not complete row

You say that if A contains data then B, C and D will also contain data. Do
you wish to copy all four of these cells, or just A

Just A

were you planning on
deleting the contents of B, C and D after the copy?

No. Just A