Adding Missing Dates

I  have a column dates in MM/DD/YYYY format

Some of the dates are missing, I want to fill the missing dates in with a blank row, How can I do this in Excel 2007. 

August 5th, 2013 12:39am

Function KeepInOrder() As Byte
  Dim N As Long
  Dim rng As Range

  Set rng = Selection.Columns(1).Cells
  For N = rng.Count To 2 Step -1
     If (rng(N).Value - 1) <> rng(N - 1).Value Then
        rng(N).Insert shift:=xlShiftDown
     End If
  Next
End Function
'---
Jim Cone
Portland, Oregon USA
Special Sort Excel add-in
(30 ways to sort)

Free Windows Admin Tool Kit Click here and download it now
August 5th, 2013 8:18am

Forgive me, but I'm not too familar with how to use Macros or scripts in Excel, can you provide some instruction on how to implement that?

August 5th, 2013 2:56pm


http://www.contextures.com/xlvba01.html
(adding code to an excel workbook)

'---
Jim Cone
free & commercial excel programs
Free Windows Admin Tool Kit Click here and download it now
August 5th, 2013 3:16pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics