Cut/Paste Same Sheet Always Running Macro

[That1Guy1]

Hey Everyone,

Any help is greatly appreciated. Every post I see for this is cut and paste into a different sheet instead of same sheet.

What I am looking for would be:

A marco that is always running, that when the word "Confirmed" is placed into a cell in Column E, that it will cut that row (Specifically the data from in that row from column A-I) and paste it (on the same sheet) starting at A3 (or next available row that does not have data). The Sheet is called HotList 2016. Any help is greatly appreciated, I've tried several modifications to codes that cut and paste into a different worksheet and can not get it to work!

Thank you for your help!

All the best,

 

[That1Guy1]

Bump.

 

[LloydFinancials]

Hi,

Here is example data that I used. See if the code below helps get you started.

Excel 2010
	A	B	C	D	E
1	1
2	2
3	3
4	4
5
6
7
8
9
10	5				Confirmed
11	6
12	7
13	8				Confirmed
14	9
Sheet2

Sub Confirmed()
lastrowE = Cells(Rows.Count, 5).End(xlUp).Row
For i = 1 To lastrowE
  lastrowA = Range("A1").End(xlDown).Row + 1
  If Cells(i, 5).Value = "Confirmed" Then
    Rows(i).EntireRow.Cut
    Range("A" & lastrowA).EntireRow.Select
    Selection.Insert Shift:=xlDown
  End If
Next i
End Sub