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?

repeating data in column to empty cells below without overwriting
 

Debra's page has the methods to do what you want:
http://www.contextures.com/xlDataEntry02.html
Excel -- Data Entry -- Fill Blank Cells
Fill Blank Cells
Fill Blank Cells Programmatically
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jeffchina" wrote:
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?