You might want to take a look at using Data - Filter - AutoFilter.

This would display your desired data, and is probably the simplest answer.
Is there a particular reason you wanted to split the data up?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jxbeeman" wrote:

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