Macro to insert specific number of rows, populate rows with data above except date

Hello,

I am hoping to get help with a macro or solution to insert blank rows below existing data based on a number contained in the same worksheet, and populate the rows with the data above except for two columns, which would hopefully be populated with the month after the date in the source row.

I have a list which fulfills a request for documents. The list is attached. In rows 'E' & 'F' the range of documents we requested is given, in row 'J' the number of documents fulfilled is given. For instance on row 2, statements were requested for the months of AUG and SEP 2012 and for that request, 2 documents were fulfilled. I was hoping to get a VBA for something that can help me break these ranges out and give each month requested its own line.

The steps are simple, and they in the 2nd attachment also below-

Need to insert number of blank rows based on number value in "available requested"- in attached sheet, column 'k'
Copy data from above into blank rows, leaving range columns blank
Clear contents of 'Range_To'
fill blanks in 'Range_From' with first date of next month
copy 'Range_From' date into column to the right

Does this help any?

Please Login or Register  to view this content.

Yes! this will do the first several steps. It accurately adds the number of rows which is very helpful.

I still need the macro to fill the blank rows in column e with the date of the first day of the following month, something I can't do manually very easily..

to fill the blank rows

Please Login or Register  to view this content.

Kind regards
Leo

Leo-
Thank you but the filled dates are wrong- see attachment, would need the first date of the following month added in, right now it is doing January 2012?

Thank you again!

did you change the first line in code ?

Please Login or Register  to view this content.

because if i run the code it is perfect


Kind regards
Leo

I've tried it and re-tried it, and I still get it filling in January as the next month...not sure why?

What result you get in this ?
with the code in macro 1

With the cod ein Macro one I get

01/09/12 1/9/2012

where it should be 9-1-2012. I checked formatting issues but I don't think that's the cause of it.

Try:

Please Login or Register  to view this content.

This does the trick! THANK YOU John!!!

You're welcome. Glad to help out and thanks for the feedback.