Compare 2 files

[Karleen1977]

Hi all,

I am looking to automate a process. I have 2 excel docs, that I need to compare. We have been doing this process manually for a very long time and it takes up a lot of our time.

I think an IF/THEN/ELSE script will work, but I'm stuck on one part.

What I need to know is the differences between book 1 and exporttoexcel are:

Book 1		Exporttoexcel
Column B (STD_LIST_ITEM_NUM)	VS	Column A (ITEM)
Column F (STD_LIST_PART_NUM)	VS	Column B (IDENTIFICATION)
Column J (STD_LIST_QUANTITY)	VS	Column D, E, F, etc (G1, G2, G3) (SEE BELOW FOR MORE INFO)

Exporttoexcel doc is the new list that I need to update book 1 to match.

My big issue is that on exporttoexcel, there are multiple groups (G1, G2) it could be 40+ groups. and I'm only working with one group at a time. If you look at the table I show below, for in G1 and G2, the difference is item 41. If I'm working with G1 I need to ignore item 41 (test45).

On each excel file, I need to see the differences.

Any help or suggestions would be appreciated.

thank you!

book 1.xls
	A	B	C	D	E	F	G	H	I	J	K	L
1	STD_LIST_SEQUENCE	STD_LIST_ITEM_NUM	STD_LIST_IN_CODE	STD_LIST_DELETE_CODE	STD_LIST_EXPL_LVL	STD_LIST_PART_NUM	STD_LIST_PART_DESC	STD_LIST_PART_NUM_CODE	STD_LIST_PHANTOM_STATUS	STD_LIST_QUANTITY	STD_LIST_ASSOC_PB	ITEM_STATUS
2	10	DL240		N	1	test1	WATER PIPE ASM	G	P	1		Active
3	20	1		N	1	test2	BOLT, 12 POINT M-14X130	G	R	12		Active
4	30	2		N	1	test3	SEAL WATER FACE	G	R	5		Active
35	340	36		N	1	test34	PIPE ASM IC RETURN	G	R	1		Active
36	350	37		N	1	test35	PUMP HT OUTLET	G	R	1		Active
37	360	38		N	1	test36	PUMP LT OUTLET	G	R	1		Active
38	370	39		N	1	test37	PUMP HT INLET PIPE	G	R	1		Active
39	380	40		N	1	test38	WATER PIPE JUNCTION CAST	G	R	1		Active
40	390	41		N	1	test39	PIPE STRAIGHT	G	R	2		Active
41	400	42		N	1	test40	WATER PIPE CONNECTION	G	R	0		Inactive
42	410	43		N	1	test41	PIPE EGR SUPPLY	G	R	1		Active
43	420	44		N	1	test42	THERMOSTAT VALVE	G	R	1		Active
44	421	PS		N	2	test43	THERMOSTAT	G	A	4		Active
45	422	PS		N	2	test44	LIP SEALS (O-RING FOR ELEMENT)	G	A	1		Active
book 1

exporttoexcel.pl
	A	B	C	D	E	F	G	H
1		Parts List For:	xxxxx
2		Date:	1/4/2023
3		PL IN.:
4		PL.Desc.:
5		Prod.Line:
6		PL.Rev.:	C
7		1st Made For:
8		DS:
9
10	Item	Identification	Description	G1	G2	UM	Zone	MB
11	1	test2	BOLT, 12 POINT M-14X130	2	2	EA		B
12	2	test3	SEAL WATER FACE	2	2	EA		B
46	37	test35	PUMP HT OUTLET	1	1	EA		M
47	38	test36	PUMP LT OUTLET	1	1	EA		M
48	39	test37	THERMOSTAT VALV E	1	1	EA		B
49	40	test38	WATER JUNCTION MACHINING	1	1	EA		M
50	40.1		test10000	1	1	EA		B
51	41	test39	TWIN WATER PIPE ASM	2		EA		M
52	41	test45	TWIN WATER PIPE ASM		2	EA		M
53	42	test40	COVER PLATE	1	1	EA		M
54	43	test46	EGR WATER INLET PIPE	1	1	EA		M
55	44	test42	ENGINE HT IN	1	1	EA		M
56	45	test47	LOCTITE 222	A/R	A/R	FO		B
57	46	test44	LUBRICANT SUPER O LUBE	A/R	A/R	FO		B
exporttoexcel