I am completely blocked on this one.
I need to copy a range of cells, A1,B1,C1, A2, B2, C2 etc. etc. Until a blank row, and then put them into a new workbook.
All straight forward enough so far.
But I also need to concatenate the contents of all B column cells, to paste in a single cell in the destination workbook with the other copied cells.
Any pointers on this would be appreciated
'If at first you don't succeed, then your hammer is below specifications'
I need to copy a range of cells, A1,B1,C1, A2, B2, C2 etc. etc. Until a blank row, and then put them into a new workbook.
All straight forward enough so far.
But I also need to concatenate the contents of all B column cells, to paste in a single cell in the destination workbook with the other copied cells.
Any pointers on this would be appreciated
'If at first you don't succeed, then your hammer is below specifications'