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.
Technology Tips and News
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.
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)
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?