VBA - Code to compare 2 columns

Hi,

The code below was provided by another poster at Ozgrid. As of now, it will only compare column B to column A and return the differences in column C. I may need to use the code to compare column C with column A and B and return the differences in Column D, etc, but I don't understand any of it.

Can someone break it down and add some explanation text to help me understand the code?

Thanks :-)

Please Login or Register  to view this content.

back to the top

In addition to all the previous comments - might also just be a simple excel formula solution for your comparisons - if you described what you wanted or provided a sample workbook I'm sure we could figure out the best method for you.

Jindon wrote this code. It works like a charm when I am comparing two columns, but unfortunately I can't tweak it in case I need to use the code in another workbook/increase the number of columns up for comparison.

I have attached a sample workbook and an explanation inside. Thanks for the replies!

Yup, the code he provided looked simple but I could not make minor modifications to it (even after hours of googling). I'll take a look at the sample you provided tonight. The office runs Excel 2003 and I can't install the compatibility package for some reason. Thanks for the help.

I won't be marking this thread 'Solved' just yet so that I can post some questions/problems I run into when adapting the sample.

See........

Sorry for not replying to this thread, I repped those I could. Smuzoen, thanks for the code. It's a lot easier to understand what's going on with your method but the regex method is cleaner and it seems there are less lines to change if it ever needs modification.

So I'm getting back to this project after a month's break... Ran through the whole list and found some errors.

I need this part changed yet again:

Please Login or Register  to view this content.

CAF076-1018, CAF076-101-- and CAF076-1019M are all basically the same items. Is there a way to change the pattern such that it only compares up to the third character after the hyphen and not the whole line? I tried this

Please Login or Register  to view this content.

but I don't think its any different from the current code.

Who are you talking to?

Hi Guys

The OP started a new thread which I closed for being a duplicate. I then received a PM from him basically saying the new thread request was sufficiently different to warrant a new thread. I re-opened the new thread but told him that adding a post here would bump the original thread up and would have a better chance of bringing your responses.

Here's the new thread: http://www.excelforum.com/excel-prog...21#post2885121

Originally Posted by smuzoen

I assume the OP is talking to you Jindon as OP would prefer to use regex - that is my reading of thread that is why I did not respond.

Originally Posted by jindon

Who are you talking to?

I created another thread to open the question to all the gurus here.

The question is directed at anyone who can help me with a new regex pattern.

I thought so, coz I never found any appreciation from the op not only this thread I have helped.

Not sure if serious.

I added to your reputation (with a thanks comment) for the help because I didn't want to clutter the thread with posts not really related to the topic at hand. Also did the same for Smuzoen. Funny how it says "you cannot give reputation for the same post twice" but shows that I haven't given out any thanks/likes. Also thanked you in ozgrid before I moved here.

Meh.

Are you kidding?

No record in my reputation list from you at all.

No I am not kidding. Repped both you and Smuzoen. If it didn't get through for whatever reasons, then I'm sorry but I know I did. I also thanked you in that other thread.

Now please stop derailing this thread.

Bump to the top

Hi Anthony, today is my last day interning at this company and I don't have access to these Excel files from home. The excel project was one of the assignments I had to do in my few months here. If the company thinks they'll be needing the macro, I'm sure they'll be able to get someone else to work on it in the future..

Thanks for all those who pitched in ITT.