arou_1 0 Newbie Poster

Hi guys, please help me to solve the problem below.

I have 2 excel files, from which i have to make a match from column D ( 1st excel file) and column G (2nd excel file).
e.g 1st excel file, column D :
A1= 02359 8745TFR 2560114
A2= 589TFR2658 2568751...

2nd excel file, column G:
A1= 2545225LO B155544
A2= 54545TFR56 62560118...

Since A1(1st excel sheet) match with A2 (2nd excel sheet) as they have the same value in different position(UNDERLINED ONLY).

How to determine the matching by writing code using vb 6.0?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.