I have an Excel 2010 sheet that is filled automatically with data from another worksheet. By hand I have to fill up all the cells in column C with the word “water” until I reach a set of four cells.
I would love to have that done automatically too, but don’t really know where to start. The problem is that the number of filled cells in column C varies every time (but always with a set of 2 cells). The range of cells that is automatically filled with data is from C8-C55. It is always filled with 2 cells at the same time. When the number of cells cannot be devided by 4, I would like to have more cells in this range filled with the word "water" until the filled number of cells can be devided by 4.
Can anyone help me with this?