G'day,
I've got a table where information can be entered in cells from B3 to F43. These cells may be selected individually or in groups and merged (within the one column) of 2 to 8 cells.
I would like to use VB, so that when a cell, or a group of cells is selected, for instance B10 to B14, the information in B2, A10 and A14 is automatically entered into a different table. So, the info in B2 would appear in the first available blank cell in column AM. The info in A10 would appear in the first available blank cell in column AN, and the info in cell A14 would appear in the first available blank cell in column AO. Each of these columns (AM, AN and AO) have a blank cell in Row 1 (which is not part of the table) and Row 2 is their header, the information needs to fill in below that.
Hopefully this is possible....
Many thanks,
I've got a table where information can be entered in cells from B3 to F43. These cells may be selected individually or in groups and merged (within the one column) of 2 to 8 cells.
I would like to use VB, so that when a cell, or a group of cells is selected, for instance B10 to B14, the information in B2, A10 and A14 is automatically entered into a different table. So, the info in B2 would appear in the first available blank cell in column AM. The info in A10 would appear in the first available blank cell in column AN, and the info in cell A14 would appear in the first available blank cell in column AO. Each of these columns (AM, AN and AO) have a blank cell in Row 1 (which is not part of the table) and Row 2 is their header, the information needs to fill in below that.
Hopefully this is possible....
Many thanks,