I have looked at a lot of different ways to do this and tried to incorporate their ideas into this sub but I keep getting different errors every time I run it. I am searching for “0” in the listed ranges of the STATUS SHEET and finding the offset value which is the vehicle number. then finding that vehicle number on LRV ISSUES and pasting “OOS” one cell to the right. It seems to work once and then errors so I am thinking my looping is wrong. Thanks for any help.