I have a work sheet that contains 12 columns and 67 rows. A1 to L67.
A1 to A67 contains the contents. B1 to L67 contains a unique reference
numbers for example CC 407.1. The unique reference numbers do not appear in
every cell. The cells that contain a reference no are colored.

Is there any way to select the cells by clicking on them and when all the
selections are made pressing a command button and the selections go into a
cell in sequence separated by a comma. There may be 1 to 100 selections.

If this is possible any help is appreciated.