please see attached file.
in the example uploaded, there are two sheets, Data and Extract
in the Extract sheet, I want to put a formula that extracts all rows and puts them in sheet Extract if the Column A of Data sheet cells contain a string *Manager*
see Extract sheet that is how the data should look like after put the formulas there.
I know how to do this with auto filter and copy and paste in there. but is there any way to get this done by formula? if formula is not possible at all then VBA