I would like to be able to automatically move a cell value if a specific value is listed. For example there was a zero in line 9 column H I would like to move the value in cell address line 9 column G to line 9 column J. Does anyone know how to do this? Thank you in advance for any information you could give.