abdo meghari
Well-known Member
- Joined
- Aug 3, 2021
- Messages
- 717
- Office Version
- 2019
hello
I have sheets (TIRES,TIRES1,FS,BS) should match sheet TIRES for column B with sheet FS if the items are existed in sheet TIRES but not existed in sheet FS then should delete them from sheet TIRES and put the similar items into adjacent cells for sheet TIRES based on sheet FS . the same thing for sheet TIRES1, BS
result
I have sheets (TIRES,TIRES1,FS,BS) should match sheet TIRES for column B with sheet FS if the items are existed in sheet TIRES but not existed in sheet FS then should delete them from sheet TIRES and put the similar items into adjacent cells for sheet TIRES based on sheet FS . the same thing for sheet TIRES1, BS
list1.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | ITEM | BRAND | ||
2 | 1 | BS 175/70R13 B25 INDO | ||
3 | 2 | BS 175/70R13 EP150 THI | ||
4 | 3 | BS 195/60R15 AR20 INDO | ||
5 | 4 | BS 195/60R15 EP150 THI | ||
6 | 5 | BS 195/60R15 T001 JAP | ||
7 | 6 | BS 195/60R15 150EZ THI | ||
8 | 7 | BS 195/65R15 MY02 THI | ||
9 | 8 | BS 205/70R15 694 JAP | ||
10 | 9 | BS 185/70R13 EP150 INDO | ||
11 | 10 | BS 175/65R14 EP150 THI | ||
12 | 11 | BS 175/65R14 B25 INDO | ||
13 | 12 | BS 175/70R14 EP150 THI | ||
14 | 13 | BS 175/70R14 MY02 THI | ||
15 | 14 | BS 185/65R14 TEC THI | ||
16 | 15 | BS 185/65R14 150EZ INDO | ||
17 | 16 | BS 185/65R14 EP150 INDO | ||
18 | 17 | BS 195/70R14 150EZ INDO | ||
19 | 18 | BS 185/65R15 TC10 INDO | ||
20 | 19 | BS 185/65R15 T005 INDO | ||
21 | 20 | BS 185/65R15 T01 JAP | ||
22 | 21 | BS 185/65R15 B250 JAP | ||
23 | 22 | FS 205/55R16 RE003 THI | ||
24 | 23 | FS 205/65R15 EP150 INDO | ||
25 | 24 | FS 205/65R15 MY02 THI | ||
26 | 25 | FS 195/65R15 EP150 THI | ||
27 | 26 | FS 195/65R15 EP150 JAP | ||
28 | 27 | FS 195/65R15 T001 JAP | ||
29 | 28 | FS 195/55R16 EP300 THI | ||
30 | 29 | FS 205/65R15 TZ700 JAP | ||
TIRES |
list1.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | ITEM | BRAND | ||
2 | 1 | BS 175/70R13 B25 INDO | ||
3 | 2 | BS 175/70R13 EP150 THI | ||
4 | 3 | BS 195/60R15 AR20 INDO | ||
5 | 4 | BS 195/60R15 EP150 THI | ||
6 | 5 | BS 195/60R15 T001 JAP | ||
7 | 6 | BS 195/60R15 150EZ THI | ||
8 | 7 | BS 195/65R15 MY02 THI | ||
9 | 8 | BS 205/70R15 694 JAP | ||
10 | 9 | BS 185/70R13 EP150 INDO | ||
11 | 10 | BS 175/65R14 EP150 THI | ||
12 | 11 | BS 175/65R14 B25 INDO | ||
13 | 12 | BS 175/70R14 EP150 THI | ||
14 | 13 | BS 175/70R14 MY02 THI | ||
15 | 14 | BS 185/65R14 TEC THI | ||
16 | 15 | BS 185/65R14 150EZ INDO | ||
17 | 16 | BS 185/65R14 EP150 INDO | ||
18 | 17 | BS 195/70R14 150EZ INDO | ||
19 | 18 | BS 185/65R15 TC10 INDO | ||
20 | 19 | BS 185/65R15 T005 INDO | ||
21 | 20 | BS 185/65R15 T01 JAP | ||
22 | 21 | BS 185/65R15 B250 JAP | ||
23 | 22 | FS 205/55R16 RE003 THI | ||
24 | 23 | FS 205/65R15 EP150 INDO | ||
25 | 24 | FS 205/65R15 MY02 THI | ||
26 | 25 | FS 195/65R15 EP150 THI | ||
27 | 26 | FS 195/65R15 EP150 JAP | ||
28 | 27 | FS 195/65R15 T001 JAP | ||
29 | 28 | FS 195/55R16 EP300 THI | ||
30 | 29 | FS 205/65R15 TZ700 JAP | ||
TIRES1 |
list1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | ITEM | BRAND | QTY | ||
2 | 1 | FS 195/65R15 EP150 THI | 27410 | ||
3 | 2 | FS 195/65R15 EP150 JAP | 28445 | ||
4 | 3 | FS 195/65R15 T001 JAP | 29480 | ||
5 | 4 | FS 205/65R15 EP150 INDO | 25340 | ||
6 | 5 | FS 205/65R15 MY02 THI | 26375 | ||
7 | 6 | FS 205/65R15 TZ700 JAP | 31550 | ||
8 | 7 | FS 195/55R16 EP300 THI | 30515 | ||
9 | 8 | FS 205/55R16 RE003 THI | 24305 | ||
FS |
list1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | ITEM | BRAND | QTY | ||
2 | 1 | BS 185/65R15 B250 JAP | 18095 | ||
3 | 2 | BS 195/60R15 AR20 INDO | 2300 | ||
4 | 3 | BS 195/60R15 EP150 THI | 500 | ||
5 | 4 | BS 195/60R15 T001 JAP | 1535 | ||
6 | 5 | BS 195/60R15 150EZ THI | 2570 | ||
7 | 6 | BS 195/65R15 MY02 THI | 3605 | ||
8 | 7 | BS 205/70R15 694 JAP | 4640 | ||
9 | 8 | BS 185/65R14 TEC THI | 10850 | ||
10 | 9 | BS 185/65R14 150EZ INDO | 11885 | ||
11 | 10 | BS 185/65R14 EP150 INDO | 12920 | ||
BS |
result
list1.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | ITEM | BRAND | ||
2 | 1 | FS 195/65R15 EP150 THI | ||
3 | 2 | FS 195/65R15 EP150 JAP | ||
4 | 3 | FS 195/65R15 T001 JAP | ||
5 | 4 | FS 205/65R15 EP150 INDO | ||
6 | 5 | FS 205/65R15 MY02 THI | ||
7 | 6 | FS 205/65R15 TZ700 JAP | ||
8 | 7 | FS 195/55R16 EP300 THI | ||
9 | 8 | FS 205/55R16 RE003 THI | ||
TIRES |
list1.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | ITEM | BRAND | ||
2 | 1 | BS 185/65R15 B250 JAP | ||
3 | 2 | BS 195/60R15 AR20 INDO | ||
4 | 3 | BS 195/60R15 EP150 THI | ||
5 | 4 | BS 195/60R15 T001 JAP | ||
6 | 5 | BS 195/60R15 150EZ THI | ||
7 | 6 | BS 195/65R15 MY02 THI | ||
8 | 7 | BS 205/70R15 694 JAP | ||
9 | 8 | BS 185/65R14 TEC THI | ||
10 | 9 | BS 185/65R14 150EZ INDO | ||
11 | 10 | BS 185/65R14 EP150 INDO | ||
TIRES1 |