Macro for follow-up [Closed]

Report
Posts
1
Registration date
Thursday February 9, 2017
Status
Member
Last seen
February 9, 2017
-
Hello,
I receives file every week for an error message from integrations , I would like to build some macro or function which can help me to Identify whether there is any progress in data quality meaning is there any data quality improvement from last week to this week

I have data in Col-1 as Error message, Col- 2 as Count and Col-3 as Region.
For Eg:

For WEEK 1
Error Message Count Region
National ID Type 1 is blank 2 Mexico
National ID Type 1 is blank 1 Algeria
VisaID is blank 1 Spain
VisaID is blank 3 Algeria

For WEEK 2
Error Message Count Region
National ID Type 1 is blank 5 Mexico
VisaID is blank 1 Spain
VisaID is blank 2 Algeria

by looking at this two example you can say that there is more issues in National ID Type bank 1 is blank in Mexico (Which was 2 in mexico for Week 1 file and its now 5 in Week 2 file ).

where as there is no issue in Algeria for National ID Type bank 1 is blank ( Which was 1 in Week 1 file where as its resolved and no issue found in Week 2 file ).

like wise I want to create master sheet which help me to track each issue whether its fixed or not yet or its increased more then last week.

Per this I want to build some macro to track this or any function which can help.

Any suggestions are appreciated.

Thanks for your time in advance,
Asha

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!