I have spreadsheet that holds all the information needed. The value in one
column must be one of three words. Manufactured, Purchased, Obsolete. I
would like to pull a list in a new tab of all "Manufactured" parts. I do not
need the entire row, just the cell values of a few columns. So for example:
Master List (sheet 1):
clm"A" clm"C" clm"F"
Part1 qty manufactured
Part3 qty purchased
Part4 qty obsolete
Part5 qty purchased
Part6 qty manufactured

If I enter "manufactured" in to A1 on sheet 2, part1 and part6 will fill-in
in the rows below. I would also want the qty to fill in those rows as well.
Hope this makes sense!

Thanks in advance.