How can I provide linking between a cell (within pivot table) and RichTextBox.
I am creating a excel report where I have a pivot table with two columns ID and Name. The requirement is to show Description (this is another attribute) in a separate TextBox/RichTextComponent. When clicked on a particular Name, respective Desription has to be displayed in the TextBox/RichTextComponent.

Welcome for all your suggestions,