Add rows between months
Hello all.
I have 10 years worth of data that I would like to separate by month.
As of now there is no separation between, for example, January and
February of 2000. An example is this:
01/04/2000
01/10/2000
01/26/2000
02/05/2000
02/17/2000
I would like a macro that would automatically insert three rows between
each month. This is tricky because there are a differing number of
entries for each month. January might have three, while February has
2, etc. I would like this to be applied to the entire 10 year period.
Any help is appreciated. Thanks.
|