ThrottleWorks
Excel Ninja
Hi,
I am trying to perform below mentioned Copy and Paste function with macro.
I have 2 different files, file 1 and file 2. I need to copy a range of 10 columns (for example) and paste it in file 2.
The problem is I need to match headers before pasting the data.
Say Column Header 'Bike Make' is at column B in file 1 and the same is at position column E in file 2.
Then I need to copy Column B of file 1 which is 'Bike Make' and paste in the Column E of the file 2.
I remember reading the solution earlier on the Forum itself but not could locate now.
Can anyone please help me in this.
Sorry for not uploading sample file.
I am trying to perform below mentioned Copy and Paste function with macro.
I have 2 different files, file 1 and file 2. I need to copy a range of 10 columns (for example) and paste it in file 2.
The problem is I need to match headers before pasting the data.
Say Column Header 'Bike Make' is at column B in file 1 and the same is at position column E in file 2.
Then I need to copy Column B of file 1 which is 'Bike Make' and paste in the Column E of the file 2.
I remember reading the solution earlier on the Forum itself but not could locate now.
Can anyone please help me in this.
Sorry for not uploading sample file.