Excel: Auto Insert Row before Monday with Formula & formatting

Hi... In column H I have a list of dates as I will add new rows each day for different records - it's a payment collection. e.g. 18/06/14 18/06/14 19/06/14 19/06/14 19/06/14 21/06/14 23/06/14 21/06/14 is Saturday & 23/06/14 is Monday, Sunday is holiday so that day is no collection but I want Sunday row also be there with date in that column. Currently I am doing it manually. Is there a method with VBA (or other) to automatically insert a row with formulas & formatting above Monday date after workbook save. Please note I have data validations, conditional formatting & lot of formulas there. I have other date column also on workbook but I want it happens only with column with H. Also what if I have to change column H in future…please help me. Thanks in Advance.

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of June 21, 2014.

For more resources for Microsoft Excel