I have a worksheet (S1) that I want to, from a separate sheet (S2) (same
workbook) search a colum in S1 and find each case where "P" occurs and return
all of the data from that "P" row. Furthermore, I want to omit the rows in
S2 where the "P" does not occur so that it will generate a compact report.
Any thoughts?