I have a big worksheet in Excel 2010 with many lines (more than 2000) and different fields but I forgot to place some of the cells when I first entered them.
Now, when I use the filter function to try to correct and fill in the empty fields Excel won’t lt me do that adequately.
Does anyone know how to do that?
For instance, I need to fill in the field called DATE (column C), but there are lots of other lines, so I use the filter to choose only the lines with the word “Faxineira” in column B.
A good solution would be to copy column A to column C, but that doesn’t work when I am in the filter mode.