Macro is just not doing what I want it to as in filtering

[tweacle]

Hi

I have a macro that deletes matching entries but it dont seem to be doing what I want it to and I have found out if I filter by individual machines then it works.

The macro I have at the moment is shown below. Also attached is the workbook that its in.

What im trying to do is set it up so it filters it out by machine before the macro runs and then moves onto next machine and carry's on until it gets to and runs the last machine. The machine number will always be in column A of both sheets

Any ideas?

Option Explicit

Please Login or Register  to view this content.

[davesexcel]

The workbook sample supplied only has the code, it does not have any data to test the code.

[tweacle]

Apologies give it a go now,

[davesexcel]

What result are you looking for? Is the 5555 the only one that should not be deleted?

[tweacle]

Correct... 5555 on sheet 1 should not be deleted as there is no data to match on sheet 2 but all others can be as there are matches.

Also on sheet 2 1419 only needs to be deleted once as there only 1 entry on sheet 1 BUT if there was 2 entries the same on sheets 1 & 2 then I need them both deleted.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)