Hi
I want matching data bewteen two sheets based on column C,D contains the same data , the second sheet should delete data based on first sheet
if the same values for column C,D are existed in second sheet with matching first sheet should keeping otherwise should delete the others
as you note in first sheet there is duplicate items also second sheet , if the second sheet contains duplicates items and the same values but the duplicates are more than firs sheet then should delete it and just keep duplicates based on first sheet , and if there is new in second sheet but not existed in first sheet also should delete and if if there is new items in first sheet but not existed in second sheet should be add to second sheet all of this depend on column C,D except one case if there is the same values in column C,D but different item then should delete it .
so in other meaning
1- different values in column C,D with the same item in column B should delete it.
2- same item & values shouldn't delete it ,but doesn't duplicates more than first sheet.
3- same values for column C,D but different item in column B should delete it
4- different values and item should delete it
5- different item and different values in first sheet and not existed in second sheet should add second sheet .
6- same item & values in first sheet and not existed in second sheet should add to second sheet
7- differen item & values for column C,D should delete from second sheet
thanks
result
I want matching data bewteen two sheets based on column C,D contains the same data , the second sheet should delete data based on first sheet
if the same values for column C,D are existed in second sheet with matching first sheet should keeping otherwise should delete the others
as you note in first sheet there is duplicate items also second sheet , if the second sheet contains duplicates items and the same values but the duplicates are more than firs sheet then should delete it and just keep duplicates based on first sheet , and if there is new in second sheet but not existed in first sheet also should delete and if if there is new items in first sheet but not existed in second sheet should be add to second sheet all of this depend on column C,D except one case if there is the same values in column C,D but different item then should delete it .
so in other meaning
1- different values in column C,D with the same item in column B should delete it.
2- same item & values shouldn't delete it ,but doesn't duplicates more than first sheet.
3- same values for column C,D but different item in column B should delete it
4- different values and item should delete it
5- different item and different values in first sheet and not existed in second sheet should add second sheet .
6- same item & values in first sheet and not existed in second sheet should add to second sheet
7- differen item & values for column C,D should delete from second sheet
thanks
DAILY.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | DATE | CODE | BRAND | QTY | QTY1 | ||
2 | 11/21/2020 | CC1 | FOOD1 | 234 | |||
3 | 5/21/2020 | CC2 | FOOD2 | 78 | |||
4 | 5/22/2020 | CC3 | FOOD3 | 98 | |||
5 | 5/23/2020 | CC4 | FOOD4 | 56 | 45 | ||
6 | 5/24/2020 | CC5 | FOOD5 | 34 | |||
7 | 5/25/2020 | CC6 | FOOD6 | 234 | 67 | ||
8 | 5/26/2020 | CC7 | FOOD7 | 78 | |||
9 | 5/27/2020 | CC8 | FOOD8 | 875 | |||
10 | 5/28/2020 | CC9 | FOOD9 | 675 | |||
11 | 5/29/2020 | CC10 | FOOD10 | 500 | 87 | ||
12 | 5/30/2020 | CC1 | FOOD1 | 789 | 65 | ||
13 | 5/31/2020 | CC2 | FOOD2 | 456 | |||
14 | 6/1/2020 | CC3 | FOOD3 | 678 | |||
15 | 6/2/2020 | CC4 | FOOD4 | 456 | 67 | ||
16 | 6/3/2020 | CC5 | FOOD5 | 789 | 99 | ||
17 | 6/4/2020 | CC6 | FOOD6 | 234 | |||
18 | 6/5/2020 | CC7 | FOOD7 | 789 | 54 | ||
19 | 6/6/2020 | CC8 | FOOD8 | 56 | |||
20 | 6/7/2020 | CC9 | FOOD9 | 456 | 76 | ||
21 | 6/8/2020 | CC11 | FOOD11 | 456 | 76 | ||
FIRST |
DAILY.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | DATE | CODE | BRAND | QTY | QTY1 | ||
2 | 5/29/2020 | CC10 | FOOD10 | 500 | 87 | ||
3 | 12/21/2020 | CC1 | FOOD1 | 234 | |||
4 | 5/22/2020 | CC3 | FOOD3 | 99 | 98 | ||
5 | 5/23/2020 | CC4 | FOOD4 | 56 | 45 | ||
6 | 5/24/2020 | CC5 | FOOD5 | 34 | |||
7 | 11/21/2020 | CC1 | FOOD1 | 234 | |||
8 | 5/25/2020 | CC6 | FOOD6 | 234 | 67 | ||
9 | 5/26/2020 | CC7 | FOOD7 | 78 | |||
10 | 5/27/2020 | CC8 | FOOD8 | 875 | |||
11 | 5/28/2020 | CC9 | FOOD9 | 675 | |||
12 | 5/21/2020 | CC2 | FOOD2 | 78 | |||
13 | 5/30/2020 | CC1 | FOOD1 | 789 | 65 | ||
14 | 5/31/2020 | CC2 | FOOD2 | 456 | |||
15 | 6/1/2020 | CC3 | FOOD3 | 678 | |||
16 | 6/2/2020 | CC4 | FOOD4 | 456 | 67 | ||
17 | 6/3/2020 | CC5 | FOOD5 | 789 | 99 | ||
18 | 6/4/2020 | CC6 | FOOD6 | 234 | |||
19 | 6/5/2020 | CC7 | FOOD7 | 789 | 54 | ||
20 | 6/6/2020 | CC8 | FOOD8 | 56 | |||
21 | 6/7/2020 | CC19 | FOOD19 | 57 | |||
22 | 6/16/2020 | CC8 | FOOD8 | 56 | |||
23 | 6/16/2020 | CC8 | FOOD8 | 200 | |||
24 | 6/7/2020 | CC19 | FOOD19 | 57 | |||
25 | 6/8/2020 | CC20 | FOOD20 | 58 | |||
26 | 6/9/2020 | CC21 | FOOD21 | 59 | |||
27 | 6/10/2020 | CC22 | FOOD22 | 60 | |||
28 | 6/11/2020 | CC23 | FOOD23 | 61 | |||
29 | 6/12/2020 | CC24 | FOOD24 | 62 | |||
30 | 6/13/2020 | CC25 | FOOD25 | 63 | |||
SECOND |
result
DAILY.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | DATE | CODE | BRAND | QTY | QTY1 | ||
2 | 11/21/2020 | CC1 | FOOD1 | 234 | |||
3 | 5/21/2020 | CC2 | FOOD2 | 78 | |||
4 | 5/22/2020 | CC3 | FOOD3 | 98 | |||
5 | 5/23/2020 | CC4 | FOOD4 | 56 | 45 | ||
6 | 5/24/2020 | CC5 | FOOD5 | 34 | |||
7 | 5/25/2020 | CC6 | FOOD6 | 234 | 67 | ||
8 | 5/26/2020 | CC7 | FOOD7 | 78 | |||
9 | 5/27/2020 | CC8 | FOOD8 | 875 | |||
10 | 5/28/2020 | CC9 | FOOD9 | 675 | |||
11 | 5/29/2020 | CC10 | FOOD10 | 500 | 87 | ||
12 | 5/30/2020 | CC1 | FOOD1 | 789 | 65 | ||
13 | 5/31/2020 | CC2 | FOOD2 | 456 | |||
14 | 6/1/2020 | CC3 | FOOD3 | 678 | |||
15 | 6/2/2020 | CC4 | FOOD4 | 456 | 67 | ||
16 | 6/3/2020 | CC5 | FOOD5 | 789 | 99 | ||
17 | 6/4/2020 | CC6 | FOOD6 | 234 | |||
18 | 6/5/2020 | CC7 | FOOD7 | 789 | 54 | ||
19 | 6/6/2020 | CC8 | FOOD8 | 56 | |||
20 | 6/7/2020 | CC9 | FOOD9 | 456 | 76 | ||
21 | 6/8/2020 | CC11 | FOOD11 | 456 | 76 | ||
RESULT |