Hi,
Is there a way to build a table based on a condition?

so say i have the following table in one sheet (Sheet 1). What i would like
to do is to create a new worksheet (Sheet 2) that would pull out the entire
row if a certain condition was true. So if i wanted an even widget i would
get the following in sheet 2:
b 2 widget 10

a 1 widget 5
b 2 widget 10
c 1 widget 15
d 2 gadget 20
e 1 gadget 25
f 2 gadget 30

Thanks again,
Josh