Sub test()
Sheets("Sheet2").Select
If Sheets("Sheet2").Range("A1") <> 1 Then Exit Sub
Selection.Insert Shift:=xlDown
Rows("1:1").Select
Selection.Delete Shift:=xlUp
Sheets("Sheet1").Select
Range("B1").Select
Selection.Insert Shift:=xlDown
Range("A1").Select
Selection.Delete Shift:=xlUp
Selection.Copy
Range("B1").Select
ActiveSheet.Paste
End Sub
Sub test()
Sheets("Sheet2").Select
If Sheets("Sheet2").Range("A1") <> 1 Then Exit Sub
Selection.Insert Shift:=xlDown
Rows("1:1").Select
Selection.Delete Shift:=xlUp
Sheets("Sheet1").Select
Range("B1").Select
Selection.Insert Shift:=xlDown
Range("A1").Select
Selection.Delete Shift:=xlUp
Selection.Copy
Range("B1").Select
ActiveSheet.Paste
End Sub