I need a VBA code to apply on my excel file that could pick a starting date and the ending date from cells of one sheet and match within a range/calender of second sheet. After matching dates it shall reserve the working area from next row. e.g if my starting date is 4/5/2012 and ending number is 6/17/2012 then all rows under the range shall be reserved for further working.
Then I have number of cells in first sheet e.g 200 cells to be filled with color. So in the second sheet under the area between dates only 200 empty cells shall be filled. If there's any cell already filled it shall skip that one and pick the next one.
Please let me know if anyone is interested to work on this assignment. My Template file is also attached herewith.