I think this will work I will give it a try: http://www.excelforum.com/excel-programming-vba-macros/861184-find-and-add-missing-dates-autofill-the-newly-added-rows-save-as-csv-comma-delimited.html