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
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