Seems like this could be handled by an Advanced Filter:

1)Make sure there are column headings for your data (Desc, Val1, Val2)
2)Go to Sheet 2
3)A1: Val2, A2: 5
4)A5: Desc, B5: Val1, C5: Val2

5)Select A5:C6
6)DataFilterAdvanced Filter
Copy to another Location
List Range: Sheet1!A1:C100
Criteria Range: Sheet2!A1:A2
Copy to: Sheet2!A5:C5
Click [OK]

That should pull all items from Sheet 1 where Column C is greater than
5.

If that works for you, then we can work on totalling the non-matching
items.

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=375860