Dirk Wessels macros

[teodormircea]

I'm using Dirk Wessels' excel list compare .It works nice but it doesn't match evry thing, for example if i have more then 10000 lines and diferents format cell doesn't work anymore. I have the code. Does any one tryed to improuve this solution

 

[teodormircea]

i have an error Script out of range when i have more olumn in one of range i think
For ii = 1 To UBound(a, 2): MatchBwithin(mbw, ii) = a(i, ii): Next
End If

 

[teodormircea]

i have an error Script out of range when i have more olumn in one of range i think
For ii = 1 To UBound(a, 2): MatchBwithin(mbw, ii) = a(i, ii): Next
End If
and it is possible to put the results in a ne sheet
if you have time because i want to learn can you join in the codes some explanations

in rest is ok im gone make tests and give you a feed back

 

[teodormircea]

i have an error Script out of range when i have more columns in one of range
For ii = 1 To UBound(a, 2): MatchBwithin(mbw, ii) = a(i, ii): Next
End If
can i see in the results the ranges that have singles values (no match no doubles)
it is possible to put the results in a new sheet
if you have time because i want to learn can you join in the codes some explanations

in rest is ok im gone make tests and give you a feedback

what was your way to learn vba??

 

[teodormircea]

i have an error Script out of range when i have more columns in one of range
For ii = 1 To UBound(a, 2): MatchBwithin(mbw, ii) = a(i, ii): Next
End If

it is possible to put the results in a new sheet
if you have time because i want to learn can you join in the codes some explanations

in rest is ok im gone make tests and give you a feedback

what was your way to learn vba??

 

[teodormircea]

ALSO IN THE RESULTS FOR THE SECOND RANGE I HAVE SOME WIRD RESULTS BECAUSE DATA THAT SUPPOSED NOT TO BE MATCH ARE IN DUPlICATES

 

[jindon]

I guess you got some result...
1) Did you understand how to enter Co reference to be compared ?
2) Can you explain how it is not displaying correctly ?

Basically, my understanding is to display "all" the data distributed to the category...
Is this correct ?

 

[teodormircea]

OK

1. I can't chose more the 4 columns for each range of data
2. Some time i had to chose for the 2 ranges not equal number of columns for example ( i will have 7 columns in the first range and 6 columns in the second range)
3.Run-time error 9 Script out of range
Else
nma = nma + 1
For i = 0 To UBound(x): NoMatchWithA(nma, i + 1) = x(i): Next
End If
4. it is possible to have the results in the some book but different sheets

 

[teodormircea]

Continuing the las post >
About the duplicates found in each range it is possible to count them, i have a macros for that but it will be nice to have in the some time

 

[teodormircea]

Continuing the las post >
About the duplicates found in each range it is possible to count them, i have a macros for that but it will be nice to have in the some time

 

[teodormircea]

In my data i noticed that is possible to have blanks in the range column and the criteria column. I hope that is a usefully info