Selecting specific lines from a list depending on criteria

[ExcelRoy]

Hi all,

I am looking for a formula to only copy "Ordered" status parts from a list

So on sheet 1 i have

Col A
Quantity
Col B
Part NUmber
Col C
Description
Col D
Status

On SHeet 2 i would like all "Ordered" lines to show

What sort of formula could i use in order to achieve my "Ordered" list on sheet 2

Many Thanks

 

[ExcelRoy]

Hi Robert,

I have a workbook with 3 sheets

Sheet 1 has a list of parts with prices (Estimate)
Sheet 2 has a copied list of the (Estimate) but without the prices with the order status ie ordered, partially shipped, shipped or cancelled
Sheet 3 is a backorder list of what is outstanding at any one time

Sheet 2 is where the formulas are generated by an input of what is recieved in
ie. on column B, has the original order amount, and column Y would have the recieved amount

Here is the formula complete

=IF(B16="","",IF(B16=Y16,"Shipped",IF(OR(Y16="",Y16=0),"Ordered",IF(Y16<B16,"Partially Shipped"))))


Hope this makes sense

Thanks for your continued help