Need VBA Code to copy multiple column from closed wbs to active sheet

[julielara]

Hi experts

i have masterfile in one path, i want copy header value from sheet Header and paste column values depends upon requirement into working file.

assume"C:\Users\Windows 10\Desktop\Orcles\y-23"

Copy to active sheet from closed wb sheet(Febious_Grand_Data)
Column A = concate of column F&W from
Column C=Copy From F
Column D=Copy From W
Column E=Copy From X
Column F=Copy From Y
Column G=Copy From Z
Column H=Copy From AA
Column I=Copy From AC
Column J=Copy From v
Column k=Copy From R
Column M=Copy From AE
Column Q=Copy From AD
Column U = Default 1

find the attachment,thanks for your time

[julielara]

any experts help on this?

[julielara]

i tried this code, its not work for me

Please Login or Register  to view this content.

[jindon]

This is based on your actual data layout, not by the column references in your description in post #1.

Please Login or Register  to view this content.

[julielara]

Thanks experts saved my day legend !!solved