Vba button Comparison data between two file or two tabs

[DocAElstein]

Alternative 2

OutputAlternative2
This is just a suggestion for an alternative output format: The main difference is that the output is given in one column. We use the single “column” concatenated check data arrays ( which we already have ) , for our output instead of using the initial capture data arrays containing all columns.

Brief code description and modifications to previous codes:
My arrOut() is now only 1 column, as I am using the concatenated string ( of all 5 column data values), in the output:
_ReDim arrOut(1 To UBound(arrSht2(), 1), 1 To 1)

I remove the “|” ( which was just for my testing convenience ) and replace that with a few spaces: “___” . This will make the displayed string look more representative of the Worksheet data
So "row" elements in my check arrays now take this type of form:
_2 _ Jet _ Blue21 _ ABC _ 458 _ 458
( previously they were this form : _2 | Jet | Blue21 | ABC | 458 | 458


The rest of the code changes basically involve changing the string data put into the arrout() to be the relevant concatenated string. So we only have one “column” of output which contains all the 5 data column values

_._____________________

Here is this alternative output code:
http://www.excelfox.com/forum/showth...0762#post10762

Here is some test results:
http://www.excelfox.com/forum/showth...0763#post10763

Alan