Build a Table

[jxbeeman]

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

 

[Luke M]

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?

 

[pomegranate-man]

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

Depending on what kinds of conditions are needed, "Advanced Filter" might
meet the need using Excel 2003.

Look up "Advanced Filter" in Excel's built-in Help, or check web sources
like these:
http://office.microsoft.com/en-us/excel/HP052001781033.aspx
http://www.contextures.com/xladvfilter01.html
http://www.msofficeworld.net/2009/03/27/excel-advanced-filter/
http://lmgtfy.com/?q=excel+"Advanced+Search"