Hi ,
i have a colume a with data
I have colume b with numbers :1 or 2
I want to do this thing :
If i have in cells b1-b3 the value 1 and in cell b4 the value 2 , i want to concatenate a1-a3 and paste it into c1
If i have in cells b5 - b9 the value 1 and b10 the value 2 , i want to concatenate b5-b9 and paste into c2
If i have in cells b11-b22 the value 1 and b23 the value 2 , i want to concatenate b11-b22 and paste into c3 etc...
Is there a macro for this ?
thanks
i have a colume a with data
I have colume b with numbers :1 or 2
I want to do this thing :
If i have in cells b1-b3 the value 1 and in cell b4 the value 2 , i want to concatenate a1-a3 and paste it into c1
If i have in cells b5 - b9 the value 1 and b10 the value 2 , i want to concatenate b5-b9 and paste into c2
If i have in cells b11-b22 the value 1 and b23 the value 2 , i want to concatenate b11-b22 and paste into c3 etc...
Is there a macro for this ?
thanks