Using VB to look up information in different cells and paste it into other cells

[CrazyDave]

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,

 

[CrazyDave]

This problem was solved by a work colleague... it's all good!

 

[Peter_SSs]

Glad to hear you got the solution & thanks for trying to update solutions for old threads.

If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.