Hi,

I have one summary sheet which has a named range. On a click of the bubble the name of the bubble needs to passed to this named range.

Hope it is clear now.

Regards
Sidd