Tags: 10th, below, cell, cells, column, date, duplicate, empty, excel, following, met, microsoft, msdn, overwriting, repeating, software

repeating data in column to empty cells below without overwriting

On Microsoft » Microsoft Excel

916 words with 1 Comments; publish: Fri, 23 May 2008 18:21:00 GMT; (30647.12, « »)

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?

All Comments

Leave a comment...

  • 1 Comments
    • 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?

      #1; Fri, 23 May 2008 18:22:00 GMT