Transfer data from one file to another file

[keshavtale]

I attached two files one name is DATA second name is BEFORE or you can give it any name i want to transfer data from DATA file to BEFORE file ,
transfer data of A column to cell D4 and onward,transfer B column data to cell E4 and onward,
transfer C column data to cell AA4 and onward , transfer D column data cell AB4 and onward,
transfer E column data to AJ4 and onward, transfer F column data to cell AQ4 and onward
see before after files for what i expect

[alansidman]

Please Login or Register  to view this content.

[keshavtale]

I try to use that code i think it is need some modification or i apply that code incorrectly , i dont know what
happen , but when i run that code it is shows error "Type mismatch"

[alansidman]

When you get the Type Mismatch error, click on the debug button and then indicate which line of code is highlighted. Are you running this code on your sample workbook or some other workbook. If on another workbook, is it the exact same layout as the sample?

[keshavtale]

Please , can you apply that code in that files which i provide and take test if code running succesfully then i download that file

[alansidman]

You have code in the before.xlsm file that is password protected that is interfering with my code and I cannot see why. It is causing an input box to open when I attempt to run my code. Can;t help until that file is unlocked and analyzed.

[keshavtale]

That file provided by third party so it is not possible to unlock that code so forget about that code just do one thing if possible I want to hide some column's of before file do that if possible else remain it unsolved

[alansidman]

Can't do anything as that code is superceding any actions I try to engage. Good luck with finding a solution to this issue. I am sorry, but I cannot assist further.

[keshavtale]

OK thanks for your cooperation