Peter Quill
Member
- Local time
- Today, 18:56
- Joined
- Apr 13, 2023
- Messages
- 30
Hello,
I need to get missing values based on Sheet1, i.e. Data is in Shee1 but not in Sheet2. and duplicate from both sheets.
The output will be in a new single result sheet with Date, item, and quantity (A, B, C ) columns i.e. Missing Value in Sheet2, Duplicate Values in both sheets.
Please, compare as per the attached file with the help of VBA macro.
Thank you for every previous response!
I need to get missing values based on Sheet1, i.e. Data is in Shee1 but not in Sheet2. and duplicate from both sheets.
The output will be in a new single result sheet with Date, item, and quantity (A, B, C ) columns i.e. Missing Value in Sheet2, Duplicate Values in both sheets.
Please, compare as per the attached file with the help of VBA macro.
Thank you for every previous response!