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
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