Too tricky for me

[choomkey]

Hello everyone
I need your help to solve another problem
I would like to select a specific file in a specific folder which contains rows of numbers
Each file contains a single sheet which has multiple rows of 10 numbers
the numbers vary between 0-80
the following code was kindly provided to select the file by pressing a form button to run the macro

Sub choomkey()
Dim Fname As String, Pth As String
Pth = "C:\MrExcel\Fluff\"
Fname = "TG" & Range("A2").Value & " " & Range("B2").Value & "E " & Range("C2").Value & "L.xlsx"
Workbooks.Open Pth & Fname
End Sub

now before I press the button I would like to select 2 numbers (between 0-80) from Cells D2 and E2
On pressing the button, the macro would then return all the rows form the selected file containing both of those numbers
many thanks for your time and expertise

 

[RoryA]

Duplicate of How to select specific rows of numbers from an excel sheet

Please do not post the same question more than once. Thread closed.