parscon
02-08-2012, 12:16 PM
I need help . I have 1 column with data and want to copy all of them to another column just to 1 cell , that mean copy all data from 1 column to cell of another cloumn .
like :
Column A Column B
1 DATA1 1 DATA1 -DATA2- DATA3- DATA4- DATA5
2 DATA2
3 DATA3
4 DATA4
5 DATA5
.
if anyone canhelp me , please provide me Macro code for this .
Thank you so much .
like :
Column A Column B
1 DATA1 1 DATA1 -DATA2- DATA3- DATA4- DATA5
2 DATA2
3 DATA3
4 DATA4
5 DATA5
.
if anyone canhelp me , please provide me Macro code for this .
Thank you so much .