Hi
I had a macro that deleted matching records of which was done by fluff of which a massive help by the way.
Some of the data that downloads has now changed and I now seem to find that the only way I can get it to work properly is to filter out each individual machine first and then compare . Is there any way I can amend so that it compares each machine individually and then deletes exact matching records one on one. Sometimes there will be 1 entry on sheet 1 and duplicated ones on sheet 2 so if this was the case I only need 1 entry on sheet 2 deleting as there only 1 on sheet 1.
I had posted on here but looking for an answer asap if poss. https://www.excelforum.com/excel-programming-vba-macros/1324445-macro-is-just-not-doing-what-i-want-it-to-as-in-filtering.html
That may explain it with more sense to you all.
I had a macro that deleted matching records of which was done by fluff of which a massive help by the way.
Macro I was given dont seem to be doing what it originally supposed to do.
Hi I was given this macro and it dont seem to be doing what I want it to do anymore. What im trying to do is compare data in sheets 1 &2 and if matching entries I need them deleting from both sheets. It should then mark on sheet 1 missing or sheet 2 duplicate if it is the case. It seems...
www.mrexcel.com
Some of the data that downloads has now changed and I now seem to find that the only way I can get it to work properly is to filter out each individual machine first and then compare . Is there any way I can amend so that it compares each machine individually and then deletes exact matching records one on one. Sometimes there will be 1 entry on sheet 1 and duplicated ones on sheet 2 so if this was the case I only need 1 entry on sheet 2 deleting as there only 1 on sheet 1.
I had posted on here but looking for an answer asap if poss. https://www.excelforum.com/excel-programming-vba-macros/1324445-macro-is-just-not-doing-what-i-want-it-to-as-in-filtering.html
That may explain it with more sense to you all.