VBA which finds data in one sheet & return list with all relevant data in new sheet

[Licence]

Hi,

I'm at newbee in VBA, and I need a find and return function, that:
Finds data in one sheet
Returns all data which meet a certain criteria in another sheet

I have found VBA codes for finding data, but not codes for a function which is able to find and copy and returning all relevant data.


[INFO: The spreadsheet measures KPI based on "Data OK" and "Data Not OK", and my macros show relevant charts. But I'm not able to list of all "Data Not OK" so the user quickly can identify the data which needs to be corrected]

Any one who knows how to do it, or already have made a similar function?

Thank you, much appreciated.

Anders
Technical University of Denmark

[Bob Phillips]

I would filter the spreadsheet for those criteria, and then copty the visible data.

[Licence]

One option, but I want the function to run when the macro is activated.
All in one solution.

[Bob Phillips]

You could do those steps and record a macro, assign that to a button.