Hi All,

Hoping somebody can help.

I have the following data. Basically i want to write a formula/macro to be able to change status of Parent when all the child are closed. e.g as all child (1.1,1.2,1.3,1.4) of parent 1 are closed, the parent 1's status should be closed. I am not sure how to do that.

Key Type Status Parent Code
1 Parent Open 1
1.1 Child Closed 1
1.2 Child Closed 1
1.3 Child Closed 1
1.4 Child Closed 1
2 Parent Open 2
2.1 Child Closed 2
2.2 Child Open 2
2.3 Child Open 2