This macro will need to do this for multiple date ranges, for example:
Sheet1 has a list of date ranges; Column A is all your start dates and Column B is the ending date respectfully to each row. There will be another sheet within the same workbook, Sheet2 that has a list of dates in column A.
I need this macro code to go through each rows date range on Sheet1 and for all the dates on Sheet2 column A that fall within that date range, insert those dates under the row it scanned in column C. It needs to continue doing this until each row has been searched and executed accordingly.
Please see the files for reference below. The file before the macro is run, is the file that I would want manipulated according to the ideas above. The other file post macro run is what an example of the output would be (of course I did mine by manually scanning and inserting/moving the dates to column C.
Thanks for everyone's assistance!!!!!
post macro run.xlsx
example of file before macro is run.xlsx
Bookmarks