Navigate through a tree via VBA with parent-child columns

[lotfichen]

Hello everyone,

I am working on an excel worksheet and I have difficulties to make a link between a column K with a parent code, a column A with child code and a column I with a hierarchy level. I would like to navigate through a tree if it is possible via VBA.

Thanks for your help !!