Hello everyone,
I am a beginner of VBA and i need to create a macro for copying data from one workbook to another. The process needs to look for the header of the column on the source sheet (The headers are on the 2nd row), copying it and pasting it on the destination sheet (on another workbook). This destination sheet will have the same headers names, but on the 1st row, not like on the source sheet. It needs to be done for 4 specific columns.
Thank you everyone!
I am a beginner of VBA and i need to create a macro for copying data from one workbook to another. The process needs to look for the header of the column on the source sheet (The headers are on the 2nd row), copying it and pasting it on the destination sheet (on another workbook). This destination sheet will have the same headers names, but on the 1st row, not like on the source sheet. It needs to be done for 4 specific columns.
Thank you everyone!