I have a file that I frequently analyse. Each time I have to concatenate value in two cells but it is time consuming. I am new to vba and would appreiate if someone cal help me with a script that the will automate the process.
This is what I do:
1. Delete row 1 to row 10
2. Type heading "Classifier" in cell C11
3. Concatenate cell A14 & B14 to C14
4. Concatenate cell A20 & B20 to C20
5. Concatenate cell A25 & B25 TO C25
6. Kill the formulas in ROW C:C
7. Copy the C11 until the end of the lines below, I repeat the same for C20 and C25.
This is time consuming. sometimes I have to do the same process for more than 6000 rows.
This is what I do:
1. Delete row 1 to row 10
2. Type heading "Classifier" in cell C11
3. Concatenate cell A14 & B14 to C14
4. Concatenate cell A20 & B20 to C20
5. Concatenate cell A25 & B25 TO C25
6. Kill the formulas in ROW C:C
7. Copy the C11 until the end of the lines below, I repeat the same for C20 and C25.
This is time consuming. sometimes I have to do the same process for more than 6000 rows.