Thread: repeating data in column to empty cells below without overwriting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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?
Reply With QuoteReply With Quote