Macro for inserting missing monthly rows

Closed
Lillian888
Posts
2
Registration date
Thursday March 28, 2013
Status
Member
Last seen
April 1, 2013
- Mar 28, 2013 at 01:30 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Apr 6, 2013 at 11:07 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Mar 29, 2013 at 09:07 AM
Are these dates "Apr-99" entered exactly like "Apr-99" or they have been formatted to show up like this ?
0
Lillian888
Posts
2
Registration date
Thursday March 28, 2013
Status
Member
Last seen
April 1, 2013

Apr 1, 2013 at 05:43 PM
Hello,

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

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

Kind regards,
Lillian.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
Apr 6, 2013 at 11:07 AM
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 ?
0