I need to come up with some code that will allow me to put in a certain value "555555" where any values in column N are empty. I need to use M as the driver here meaning that I need to xlup on column M and offset by 1 so that I can apply the 555555 value to all the empty cells in N down to the last populated cell in column M. Anyone have any idea on how to do this?