repeating data in column to empty cells below without overwriting
I have an excel column that has a date every 10th cell or so. I would like to
duplicate the date into following cells until a new date is met, then that
date filled into subsequent cells and so on. Can I automate this?
|