Hi All,
Is there a formula that would populate a range from a worksheet that meets specific criteria.
i.e.Worksheet "Orders" Column (B) holds my data, but I only need to show data from specific cells/rows that start with "Supplier"
So, if any cell in column (B) starts with "Supplier", return the whole string of that cell into my table S5:S100 on Worksheet "Summary" i.e. "Supplier - Alpha Beta Marketing"
Thanks