vba macro send specific columns to another workbook

hi

i have now gone into more detail as the requirements have now changed

I'm after a macro that will copy and paste specific columns from 1 workbook to another. what i would like the macro to do is the following,



copy columns C,H,D,E,J,l,M,K,W,P,X,Y from one workbook (sheet1) and paste them to another workbook (sheet name: order book) in in column, A,B,C,D,E,F,G,H,I,J,K,L. i will have the header in row 1 so the information will need to be taken from row 2 and work its way down until it reaches the last row.

unfortunalty the macro cannot pull data by header name because both work books does not have the same headers.

please see attached , I hope it makes it more clearer.



any help will be really appreciated.

You need to post a better example workbook as you only have one sheet which does not clarify exactly what you require.

According to your attachment a beginner starter VBA demonstration to paste only to the Book2 Sheet1 worksheet module
which crashes when Book1 is not already opened or when headers do not exactly match between worksheets (no typo allowed) :

PHP Code: 

Sub Demo1()
    ['[Book1.xlsx]Sheet1'!A1].CurrentRegion.AdvancedFilter 2, , [A1:C1]
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » ! ◄ ◄