Macro to Cycle data and extract those values that meet criteria

Hi Forum,

I am wondering if anyone has a solution to my question:

I have a list of data (1,000 lines/ 15 columns, but different line amount every month) that reflect jobs that have been undertaken. For those that have failed, I need to go through the list, filtering on the relevant column to select all the "Failed" status', then copy the relevant jobs to another sheet ... this will later be published in a word for senior management.

To me it seems possible, but not sure how to code, to have a macro that will go down column a of my data (this column contains job numbers) and look in the corresponding column H of that row to see if it contains the status "Failed". If the field / job does not have this status the macro will move to the next line of data, if it does contain the status, the macro will copy the job number (column A) and populate into another sheet ... having done the copy, it will return to continue cycling through the remaining jobs.

I will then be able to use look ups on the other sheet to populate the required info needed for the Failed jobs ... as this is in a different order to the raw data I am cycling through, and do not require all the columns available in the raw data.

Thanks

Thank you for responding Alan ... much appriciated!

See your point and that is what I am current doing, but the task is slightly more demanding than that, as I have to filter multiple times to get a number of different tables and then publish into a 25 page word report (with other various imputs that have already been achieved. By using a macro it enables prcision, ease and ables me to copllate into sheet ready for a further macro to pick up and drop into the word report.

Give me 2 mins, and I will upload some sample data

Regards