Hello, I’m using ArviLaanemets solution here (FillColumnsExample.xlsm) and it is working well. I want to add a macro where if the content of a cell in column C is cleared then cells A, B and D in that row are cleared and all of the records in A,B,C and D below are moved up. I do not want to delete the whole row because of the formulas that are in columns F,G,H and I. I was going to move all the formula cells to another sheet so I could just delete the whole row but it is very convenient having them on the same sheet.