Macro for inserting missing monthly rows

[Closed]
Report
Posts
2
Registration date
Thursday March 28, 2013
Status
Member
Last seen
April 1, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Can someone please help me with writing up a macro which inserts rows, which contain missing monthly dates within a data set?

I basically want to use my worksheet used as a template for analysing different sets of data. I also need the macro to produce a scatter plot for analysing different data sets.

I need the macro to look within a data array and find the missing monthly dates. When macro has found the missing monthly dates, I need it to insert rows with the missing dates.

For example some of the dates are;

Mar-98

Nov-98

Mar-99

Mar-99

Apr-99

May-99

May-00

Dec-00


So i need someone to get excel to find the missing monthly dates from March 1998 to November 1998 and so forth. Once found to insert the missing rows.

Let me know if you have any questions. Thanks so much for any assistance you can give me or directions.

Have a great day.

Lillian.

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Are these dates "Apr-99" entered exactly like "Apr-99" or they have been formatted to show up like this ?
Posts
2
Registration date
Thursday March 28, 2013
Status
Member
Last seen
April 1, 2013

Hello,

They are formatted as "Apr-99" in excel.

Thanks for your help. Hope there is a way to solve this.

Kind regards,
Lillian.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
So if i click on the cells, i would be seeing
3/1/1998
11/1/1998
3/1/1999
3/1/1999
4/1/1999
5/1/1999
5/1/2000
12/1/2000
?
If not, then what I would be seeing ?