PDA

View Full Version : VBA which finds data in one sheet & return list with all relevant data in new sheet



Licence
01-14-2010, 01:26 AM
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
01-14-2010, 05:04 AM
I would filter the spreadsheet for those criteria, and then copty the visible data.

Licence
01-14-2010, 06:59 AM
One option, but I want the function to run when the macro is activated.
All in one solution.

Bob Phillips
01-14-2010, 10:54 AM
You could do those steps and record a macro, assign that to a button.