Copy from one workbook to another but only certain columns
My problem is that I need to copy data from workbook1 to workbook2 where the layouts are completely different.I would like to select rows in workbook1 and then run a macro to copy these to workbook2; however, I would like to copy columns from workbook1, for example, C F A D H B J E and have them appear in the order A B C D E F G H on workbook2 (so Col C in book1 would go in Col A in book2, Col F in book1 would go in Col B in book2 and so on…)
To make it slightly easier both workbooks can be open at the same time.The only alternative would be to change the layout in workbook1 to exactly match workbook2, but this is really the last resort.
Many thanks in advance.
Paul S
Solved
Try this:
In place of Wbk1 and Wbk2 write the name of your own workbooks and columns.