Loop through worksheet with 2 criteria

[tigersden]

Hi,
I have a worksheet which is used as a summary it shows monthly totals from an imported text file using dynamic named ranges.
I am trying to use a combo box to select a month and option buttons to enable selection of orders greater than 1000, 5000 & 10000 for that selected month.
I need help in working out how to loop through the data sheet and return all the matching values. I need to select from each row that matches the criteria, 5 different cells in that row (named ranges). These would be written back to another seperate sheet for analysis.
Thanks in advance
Tim

 

[Cbrine]

Tigersden,
Here's an example of how to cycle through a range of values and act upon the value.

Dim cell as range, ws as worksheet

activeworkbook.sheets.add
set ws = activesheet

for each cell in range("NamedRange1")
   If cell > 1000 then
       cell.copy ws.range("A65535").end(xlup).offset(1,0)
   End if
Next cell