merge columns vba

Greetings. I am having trouble being able to copy the last two columns with data in a worksheet and then insert the same columns to the right of them. Here is my code so far, it does not work because the top row is merge of more columns. Here is the is the screenshot link. Sub newTest()...

I need to import bank statements and convert to excel, but in the conversion process in excel I get 2 or 3 columns for each line. In order to keep the records complete I need to merge all columns. There is way or formula that I can use to merge all the columns? Thanks in advance. Nick

Hi, I've got a workbook with over 150 sheets all in different layouts. I need to extract two columns from all of the different sheets into one, the two columns are titled 'ID Client' and 'ID Holder' and unfortunately some rows are blank and the columns are not in the same position for all the...

Hello All I was looking to create a macro that would combine all column values in one single column using a delimiter (comma) I have variable column numbers per row <tbody> A D B C E F </tbody> Result: <tbody> A, D B C, E, F </tbody> Please help Apologies if this...