Appendix Thread 2. ( Codes for other Threads, HTML Tables, etc.)

[DocAElstein]

In the last code , ( Sub Testies ), the following output is obtained when using the suggested test data above ( http://www.excelfox.com/forum/showth...0756#post10756 ) :


Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Original	Original	Original	Original	Original	Original	Test Output	Test Output	Test Output	Test Output	Test Output	NEW	NEW	NEW	NEW	NEW	NEW
2			Assembly #:			Assembly Name:								Assembly #:			Assembly Name:
3	Qty Per	Ref/Designator	Description	Customer PN	Internal PN	Manufacture PN						Qty Per	Ref/Designator	Description	Customer PN	Internal PN	Manufacture PN
4	1	Nu Torque		13456	456	456						1	Nu Torque		13456	456	456
5	1	Blu Origin		Spaceship	457	457						1	Blu Origin		Spaceship	457	457
6	2	Jet Blue21		ABC	458	458	2	Jet Blue23	ABC	DEF	DEF	2	Jet Blue23		ABC	DEF	DEF
7	3	EXCELL123		123	ABC	ABC						3	EXCELL123		123	ABC	ABC
8	3	Toyota		Supra	460	460						3	Toyota		Supra	460	460
9	2	Emirate		ABC12345	461	461						2	Emirate		ABC12345	461	461
10	1	Angel		ABC12346	462	462	MISSING: 1	MISSING: Angel	MISSING: ABC12346	MISSING: 462	MISSING: 462	2	Jet Blue21		ABC	458	458

Worksheet: Result


Using Excel 2007 32 bit

Row\Col	G	H	I	J	K
1	Test Output	Test Output	Test Output	Test Output	Test Output
2
3
4
5
6	2	Jet Blue23	ABC	DEF	DEF
7
8
9
10	MISSING: 1	MISSING: Angel	MISSING: ABC12346	MISSING: 462	MISSING: 462

Worksheet: Result



Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Original	Original	Original	Original	Original	Original	Test Output	Test Output	Test Output	Test Output	Test Output	NEW	NEW	NEW	NEW	NEW	NEW
6	2	Jet Blue21		ABC	458	458	2	Jet Blue23	ABC	DEF	DEF	2	Jet Blue23		ABC	DEF	DEF

Worksheet: Result

_._____________________________________-

We have currently output like this:

Test Output	Test Output	Test Output	Test Output	Test Output
2	Jet Blue23	ABC	DEF	DEF

But We want this to look more similar to screenshot output from post #15 ( http://www.excelfox.com/forum/showth...0754#post10754 )