atditiljazi
New Member
- Joined
- Nov 22, 2022
- Messages
- 41
- Office Version
- 365
- Platform
- Windows
hi all,
I'm after a macro that will copy and paste specific columns from 1 work book 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 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.
please see attached image, I hope that makes it more clearer.
any help will be really appreciated.
.
I'm after a macro that will copy and paste specific columns from 1 work book 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 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.
please see attached image, I hope that makes it more clearer.
any help will be really appreciated.
.