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
Bookmarks