With the worksheet you posted and the code from post #4, Sheet3 is active >> alt + F8 >> run movedata >> A1:C1 from sheet3 is moved over to sheet2 because it is empty in A1.