I have four cells that I use to track items. Sometimes all cells are used and sometimes only a few. I would like help in how I can automate a move in data in a cell that is RIGHT of an empty cell move to the LEFT. (i.e.) I fill cells C5, D5, E5, & F5. I then delete the data in cell D5 and want to have the data in E5 move to D5, and F5 move to E5....leaving F5 empty for the new data. kind-of like right justify. Thank you.