I found the Sub that DerbyDad03 created called GeneFinder() and it works perfectly for finding one instance of the "gene names in sheet1" from the list in sheet3. However, if there is more than one instance of the gene names in sheet1 it will only find the first one and then move on to the next term from sheet3. I was wondering if there was anyway to do a "findAll" sort of function for the items in sheet3?
Here was the original code that DerbyDad03 posted :
Dim srchLen, gName, nxtRw As Integer
Dim g As Range
'Clear Sheet 2 and Copy Column Headings
'Determine length of Search Column from Sheet3
srchLen = Sheets(3).Range("A" & Rows.Count).End(xlUp).Row
'Loop through list in Sheet3, Column A. As each value is
'found in Sheet1, Column D, copy it top the next row in Sheet2
For gName = 2 To srchLen
Set g = .Find(Sheets(3).Range("A" & gName), lookat:=xlWhole)
If Not g Is Nothing Then
nxtRw = Sheets(2).Range("D" & Rows.Count).End(xlUp).Row + 1
g.EntireRow.Copy Destination:=Sheets(2).Range("A" & nxtRw)
Thanks in advance for any help with this!!