Delete from 2 sheets if matching criteria

Hi All,

I'm looking for a Macro that will allow me to take information on two different sheets in a workbook, and delete out lines that match based on a "concatenate" formula. Each sheet has slightly different outputs as they are reports from two different systems. Based on the attached example, I'm looking for something that will allow the following:

1) Sys 1 RPT will concatenate columns A, E, F.
2) Sys 2 RPT will concatenate columns A, D, E.

The Marco would then go through the two sheets and delete out lines in which rows with matching concatenated data string matches leaving each sheet with only rows that need to be looked at in more detail to recon and find out why they are not on the other report.

I hope this makes sense, and I'm open to other methods, if there is something easier to work with.

Please Login or Register  to view this content.

When the Macro get's the this code on the 'Sys 1 RPT' section, I get an error, no more lines detected. Then it appears that the filter being used hasn't fully completed.

Thoughts?

After walking thought it, it seems to work well till it gets to the filter aspect. The Auto filter hides the cells and doesn't go through the process of deleting rows that are still viable with a value of 1 (which appears to be the intent, correct?).

This now works perfect! Awesome!

Only question to take this one step father would be what the adjustment to the code would need to be to have the Filter fun through all the numbers that don't equal "0", and delete them as they match. As this has shown me, I have 4 on each sheet that matched that could be deleted as well. I was able to test this by changing the criteria from "1" to "4", but was curious to see the best way to have the macro to maybe circle though the numbers 1-9?

Thanks again!

So I've been using the above with a lot of success and wanted to adjust it a tad to use in a very similar form. Basically, the criteria is less this time and and can change the columns to use, but the macro always errors out in the auto filter of the "Sys 1 RPT" sheet. Seems to be the range, but no matter what I change, it doesn't seem to work.

Here is the code I'm using :

Please Login or Register  to view this content.

This is the line it always errors out on:

Please Login or Register  to view this content.

And I've attached a sample data workbook. I know this is simple, I just think I'm missing something very small.

Awesome! Thanks you soooo much!