Copy cell Next from Cell with Text "True"

[Hjemmet]

I need a Vba Code to control if one of those cell is "True"
i have try with this code but it aint work

Sub Copypast()'
' Copypast Makro


If Sheets("Copy").Range("D5").Text = "True" Then


    Sheets("Copy").Select
    Range("E5").Select
    Selection.Copy
    Sheets("Past").Select
    Range("G2").Select
    ActiveSheet.Paste
    End If
End Sub

So help Need

 

[Hjemmet]

Thank YOU that Was incredibel IT works

 

[Hjemmet]

Hey I try to Understand How it Realy Works


Now this code works For Looking on Colomn "D" and Copy from "E" so much understand i...

    p = 1 
For i = 2 To lastRow

but what is "P" for and then Number "1"
and then "For i = 2"


its because i try to make the same Function on another Colomn but its on "H" for True and "I" for Copy/past

but i would like to figure out How it was Working


NEVER MIND I CAME TO ME LIKE A HIT WITH A FLY SLAMMER..........By trying to change the Letters ()

 

[DataBlake]

but what is "P" for and then Number "1"
and then "For i = 2"

this is called a "For Loop"
its basically saying "For every row past row 2 up until the lastRow"
so these variable "i" and "p" are what im using to define the row number
so where the code says

Range("D" & i)

that means the range of the cell Di (where i is the number of the current row the loop is on)
so that means the if you have 16 rows of data in column D it will check D2 to D16

 

[Hjemmet]

Arh That Make sense

thank you for explain that