http://www.excelforum.com/excel-programming-vba-macros/1063045-macro-need-to-copy-and-paste-the-date-mentioned-in-a-column-for-all-the-values.html