Copy Paste by vba

[kamini1]

1

 

[SkipVought]

Hi,

Welcome to Tek-Tips.

Please upload a copy of the code that you are using and please note where you are having problems.

Please upload a relevant sample of target1.xlsx and target2.xlsx.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[mintjulep]

The entire column the same?

Or each cell individually?

As the first of about 27 things that you need to clarify to yourself before you make your own attempt.

 

[kamini1]

each cell individually sir

 

[SkipVought]

Please post the code that you have tried.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[strongm]

This question looks oddly familiar ...

 

[SkipVought]

Ya think? ;-)

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein