I get two excel reports that contain MOC unique numbers. One page lists the MOC number and if all acknowledgements are complete. The other page shows the actions that are associated with the MOC number. It could have multiple actions pertaining to the one MOC. These actions are open, completed or cancelled. I need to know when a particular MOC has all the action complete and/or cancelled. Then I would know that that MOC can be closed. If an action is still open then the MOC can't be closed. Does anyone have any suggestions?
Bookmarks