Compare 2 files

Karleen1977

New Member
Joined
Oct 11, 2008
Messages
13
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 1Exporttoexcel
Column B (STD_LIST_ITEM_NUM)VSColumn A (ITEM)
Column F (STD_LIST_PART_NUM)VSColumn B (IDENTIFICATION)
Column J (STD_LIST_QUANTITY)VSColumn 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
ABCDEFGHIJKL
1STD_LIST_SEQUENCESTD_LIST_ITEM_NUMSTD_LIST_IN_CODESTD_LIST_DELETE_CODESTD_LIST_EXPL_LVLSTD_LIST_PART_NUMSTD_LIST_PART_DESCSTD_LIST_PART_NUM_CODESTD_LIST_PHANTOM_STATUSSTD_LIST_QUANTITYSTD_LIST_ASSOC_PBITEM_STATUS
210DL240N1test1WATER PIPE ASMGP1Active
3201N1test2BOLT, 12 POINT M-14X130 GR12Active
4302N1test3SEAL WATER FACE GR5Active
3534036N1test34PIPE ASM IC RETURN GR1Active
3635037N1test35PUMP HT OUTLET GR1Active
3736038N1test36PUMP LT OUTLET GR1Active
3837039N1test37PUMP HT INLET PIPE GR1Active
3938040N1test38WATER PIPE JUNCTION CAST GR1Active
4039041N1test39PIPE STRAIGHT GR2Active
4140042N1test40WATER PIPE CONNECTION GR0Inactive
4241043N1test41PIPE EGR SUPPLY GR1Active
4342044N1test42THERMOSTAT VALVE GR1Active
44421PSN2test43THERMOSTAT GA4Active
45422PSN2test44LIP SEALS (O-RING FOR ELEMENT)GA1Active
book 1

exporttoexcel.pl
ABCDEFGH
1Parts List For:xxxxx
2Date:1/4/2023
3PL IN.:
4PL.Desc.:
5Prod.Line:
6PL.Rev.:C
71st Made For:
8DS:
9
10ItemIdentificationDescriptionG1G2UMZoneMB
111test2BOLT, 12 POINT M-14X13022EAB
122test3SEAL WATER FACE22EAB
4637test35PUMP HT OUTLET11EAM
4738test36PUMP LT OUTLET11EAM
4839test37THERMOSTAT VALV E11EAB
4940test38WATER JUNCTION MACHINING11EAM
5040.1test1000011EAB
5141test39TWIN WATER PIPE ASM2EAM
5241test45TWIN WATER PIPE ASM2EAM
5342test40COVER PLATE11EAM
5443test46EGR WATER INLET PIPE11EAM
5544test42ENGINE HT IN11EAM
5645test47LOCTITE 222A/RA/RFOB
5746test44LUBRICANT SUPER O LUBEA/RA/RFOB
exporttoexcel
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,223,945
Messages
6,175,555
Members
452,652
Latest member
eduedu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top