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:
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!
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 |