Excel VB宏搜索静态文本然后移动2个单元格并输入数据

I'm a noob so please bear with me. I have a workbook, Column B contains a list of ID's of the format "V000001...V000999", 1 per row these do not change and remain static. There may be anywhere from 100-1000 rows in the sheet with each of the V #'s being unique.I'm a noob so please bear with me. I have a wor