The workbook you have provided is not clear. Please provide a before and after worksheet showing exactly what you are after. Describing in a comment box somethind different than what is on the excel sheet is not helpful in this case. If you want a cell to be blank then it needs to be blank in the after sheet. If you want it populated with a specific number then it needs to reflect this in the after sheet.