I am fairly new to VBA. I need to create a macro that searches the entire column K for keywords " C Box", for any cell in this column that contains these keywords, I need to add a numerical value to the end of the text (this numerical is always in the same row as the cell that contains the keywords, but in column L)
for example:
K L
Row 43 C Box 14"
Row 55 C Box 28"
after run the macro, the text in column K becomes C Box 14" on row 43, and C Box 28" on row 55.
Any help would be greatly appreciated !
for example:
K L
Row 43 C Box 14"
Row 55 C Box 28"
after run the macro, the text in column K becomes C Box 14" on row 43, and C Box 28" on row 55.
Any help would be greatly appreciated !