```
     Sub Button2_Click() 
     'COMPARE colA and colE - if colA=colE, put colG matched to colE
     Dim rngcolE As Range, rngcolA As Range, rngFound As Range, rngSearch As Range

    Set rngcolA = Range("A2:A" & lastRowcolA)
    Set rngcolE = Range("E2:E" & lastRowcolE)

    'searches for all articlesA in column A mentioned in rngcolA:
    For Each rngSearch In rngcolA
     'all articleE are searched in rngcolE:

    Set rngFound = rngcolE.Find(What:=rngSearch, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False)

    'if articleE is found:
     If Not rngFound Is Nothing Then
       'found articlesG's cells are entered in column B, against his name given in column A:

    ngSearch.Offset(0, 1) = rngFound.Offset(0, 2)
    End If

    Next

    End Sub 

```

to be more specific:
-I have 3 filled columns (colA, colE and colG)
- if an article from colA has a match article in col E, put the matched article from column G in the second column(column B).

MY PROBLEM:
The above code is correct but all columns are in the same Sheet. 
HOW CAN I CHANGE THE CODE IF THE COLUMN-A IS IN THE SHEET1 AND THE COLUMN-E AND COLUMN-G ARE IN SHEET2 ?