Excel Matching Macro

[Coeus]

Hi all,

Hope all is well.

Here to consult with the macro saavy to illuminate the error of my ways!

I've written a macro to compare data from one sheet to another and, if the data if not found in the latter, insert that data at the end of that sheet.

Unfortunately, though the macro runs, it does not seem to insert the missing data!

I would really appreciate any input on this!

Please Login or Register  to view this content.

Many thanks for any and all help! If you could explain any errors / improvements / theory I am missing I would greatly appreciate it.


Coeus.

[ragulduy]

I'm guessing the problem is that you define and test EEENAME but you assign your range to EEERange.

So EEENAME is empty, when you test if it's an array it returns false, so skips to the end.

Try changing:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Bernie Deitrick]

Your biggest problem is that you haven't used Option Explicit at the top of your module to require variable declarations - if you had, you would have been warned that EEERANGE had not been declared.
But there is no need to transfer the values to an array:

Please Login or Register  to view this content.

[Coeus]

Many thanks both ragulduy and Bernie Deitrick!!!

That has worked perfectly however a simple adaption (or so I thought) doesnt seem to be working as I would like.

The idea is once the macro finds the first empty cell it inserts an additional row and then selects the first empty cells to put in the unmatched variable.

Could you provide any further advice? It would be greatly much appreciated

Please Login or Register  to view this content.

[ragulduy]

It would be easier to analyse with an example of your data to test it on, but I don't think you can do this:

Please Login or Register  to view this content.

I'm not sure there is such a thing as application.match, I think you mean application.worksheetfunction.match. However, I don't think you can test if it is an error like that, I think it would just say "unable to get worksheetfunction match" or something if it was going to result in an error. Maybe try doing something like:

Please Login or Register  to view this content.

instead.