Hello all,
I would like to have a code which does a concatenate operation of 1st column with the rest columns which has data and highlight it in a different color.
Eg:
Lets say i have data in 5 columns. I would like to have 1st and 2nd column's data concatenated in 6th column, 1st and 3rd concatenation in 7th column, 1st and 4th column data in 8th column and so on till end. All these concatenated data should be highlighted in any color.
Note: No.of columns may differ each time. So based on it macro need to concat the existing columns.
Thanks for your help.
Regards
Bookmarks