Vba button Comparison data between two file or two tabs

[DocAElstein]

Hi Thai,
The purpose of this post is mainly to summarise for my and others benefit the current stand of things..


I am responding here to the info I have from you on the from approx 20 – 24th July. I do note that I now have also a more recent layout from you for the result tab, but I only have a small image of that, so let me take this one step at a time, and respond to the request from up until 24th July.
Then we can take this further later.

Let me summarise for the benefit of anyone else following this Thread what I we are currently doing:
Summary of current stand , ( as I see it ).

The previous data Sheet1 and (new) data Sheet2 are now to look like this sort of format:

Previous Sheet1, now tab name is Original
Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G
1	Customer:			Assembly #:			Assembly Name:
2	#	Qty Per	Ref/Designator	Description	Customer PN	Internal PN	Manufacture PN
3	1	1	Nu Torque		13456	456	456
4	2	1	Blu Origin		Spaceship	457	457
5	3	2	Jet Blue21		ABC	458	458
6	4	3	EXCELL123		123	ABC	ABC
7	5	3	Toyota		Supra	460	460
8	6	2	Emirate		ABC12345	461	461
9	7	1	Angel		ABC12346	462	462

Worksheet: Original

Previous Sheet2, now tab name NEW
Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G
1	Customer:			Assembly #:			Assembly Name:
2	#	Qty Per	Ref/Designator	Description	Customer PN	Internal PN	Manufacture PN
3	1	1	Nu Torque		13456	456	456
4	2	1	Blu Origin		Spaceship	457	457
5	3	2	Jet Blue21		ABC	458	458
6	4	3	Alaska		789	459	459
7	5	3	Toyota		Supra	460	460
8	6	2	Emirate		ABC12345	461	461
9	7	1	Angle		ABC12346	462	462

Worksheet: NEW


Correspondingly you (Thai) have adjusted the testy Calling code to this sort of form:

Sub TestyCalls() 
 Call Testy(Worksheets("Original"), Worksheets("NEW"))
End Sub

The columns to check have changed to ……..

... display the different between the tabs "Original & NEW" from column highlighted in yellow (B, C, E, F and G)..

In other words , in the form of my previous technique in the code, it appears to me that the “unique” data entry to compare is now comprised of
B & C _ & E & F & G
(Previously this was A & B see for example test results here: http://www.excelfox.com/forum/showth...tabs#post10737

_.____________-

So this post was by way of a summary of the stand.
In the next post soon I will walk through the modifications needed to use columns B & C & E & F & G instead of columns A & B in the comparison