View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jeffchina jeffchina is offline
external usenet poster
 
Posts: 1
Default 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?