Macro Needed to Concatenate Data in separate COLUMNS

Hello,


I need a simple macro that help me to concatenate data in separate columns.
Please look at the .xls I've attached.

I would need a simpe macro where I can change the "address target" of the columns if they will be differents.


Thanks in adavance

I have a problem
I need to delete the source and the results doesn't have to change in the destinations cells when I delete the source.


how can I do???



thanks

I forgot to tell you..... the data is very large so "pastespecial" is unconfortable for me....



I would prefer a MACRO.

Please see this file attached.

Someone can code this please?


THANKS

Hello,

I need a simple mod. of this macro:

Please Login or Register  to view this content.

This macro works, but every time It ask me with a popup about the colums where put results, and the colums where read.

I need It has fixed range, and that it doesn't ask me nothing with pop-up;

Fixed values to insert are:

Selecct range for result: $T$2:$T$40000
Select range to add: $AT$2:$AT$40000


THANKS

Ps. The fixed values have to be "visible" in the macro's code, so I can change it by editing the code of the macro. Thanks

......I would need just that little mod. But I'm not able to modify the code myself.
Someone can help please?


thanks

...I tryed to modify myself but It doesn't works:


original working code (by Jindon):

Please Login or Register  to view this content.

Fixed range values to insert (for example):

T2:T40000
AT2:AT40000


This code below is modified by me; but It doesn't works:

Please Login or Register  to view this content.

someone is able to insert in this macro fixed values? .......without any pop-up that appears?


THANK YOU

.......

....PLEASE.... ......HELP ME JINDON......

...Or someone is able to modify that macro.




Thanks

This is the solution for my last question:

Please Login or Register  to view this content.