how to select row 1 to row with specific word, then shift column K of those rows by one

Hey all,

I'm hoping to create a script where I go from row 1 until I reach a row that contains a specific word in column B (in this case, a cell that begins with a comma). Then, I hope to shift column K of only the rows that I selected previously, to the right by one. How can I do this? I realize it requires the following steps.

1. Do Until or for loop that contains an if statement that checks whether cells from column B/row i starts with the character comma. If not, move onto the cell in the next row (i = i+1). If it does start with a comma, then store that row value and then break from the loop.
2. Highlight the cells from column k and row 1 through the row value stored from previous loop. Shift the cells by one to the right.

*i'm especially having trouble with the basic syntax of highlighting the cells in column k and row 1 through the previously stored row value from step 1. How do I do this? it would also be helpful if I can hear about the previous steps too in #1.

Thanks for your help.

Try this. Is there always going to be a cell in column B that starts with a comma though? If not, this will loop through every cell in column B.

Please Login or Register  to view this content.