Hi,
If I understand correctly, you want to have the value in column AL to BP filled with status, right?
I have some question
1. The secondary analysis is already covered the primary analysis, so why need the primary one?
2. If a row have "overlap" status, what to do? Set all the status in corresponding column, or have any kind of order, or how?
3. I dont understand the last paragraph: "Any Notifications left “BLANK” after the refinement/ finalization process will constitute an actual “Backlog” record and be included in the final output report"
4. What to put on BR column? I don't understand what do you mean by "composite of entire Tertiary Analysis..."
5. You want to have a macro to fill the status?
Regards,