Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
445
display parent cell when child cell have the focus
posted

Hello,

I would like to know if it was possible to have a value for a parent cell when the focus is given at a child cell? In order to display this value outside of the whdg.

for example:

parent 1    parent2    parent3    parent4    parent5

    val1               val2              val3           val4             val5     

   val11             val12           val13         val14           val15     

   val21             val22           val23         val24           val25     

parent 11    parent12    parent13    parent14    parent15

     valA               valB              valC           valD             valE     

   valAA             valAB           valAC         valAD           valAE    

   valBA             valBB           valBC         valBD           valBE

If my cell valAC    or valBE, or valA... has the focus, I would like display parent11

If the cell e.g. val22, or val12, or val4 ... has the focus, I would like to display parent1

Thanks for your answer and have a nice day.

Best Regards

Damien