Selecting Cells
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. |
All times are GMT +1. The time now is 07:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com