Linking a comment to a range
Hi,
I want to try and do a smart thing with cell comments.
The user is asked to create a custom group from a predefined list (for
example say they are a list of names).
The user types in the name of their group (e.g. "Boys") then, using tick
boxes, selects all the boys they want in that group.
What I would like to see is the name of the group appearing on the next
sheet and the cell comment to list those names that were selected.
I can manage the selected data okay, just cannot get that into a comment.
Any help would be great
Cheers
Kevin
|