I am working on a macro which will search one field for a value, if that field is has a certain value, it will go to another field, if that field is also blank it will insert some info there.

I am not sure how to complete this at all.