Auto Insert Row before Monday with Formula & formatting

[vaibhavc]

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 <acronym>VBA</acronym> (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.

 

[vaibhavc]

1) But if i remove STOP once in a day then it is adding row again & again ( before inserted row will again inserted).
2) If i have to run it manually , after pressing ALT + F8, there is macro displaying.
3) I will manage by your code (16) only date in column.

Now give me solutions for not inserting row again & again.

 

[Michael M]

Sorry, I've reached the limit of my ability.
I suggest you start a new thread, with a link back to this (you must do this or the thread will be blocked as a duplicate), and someone else may be able to come up with a solution.

 

[vaibhavc]

how can i start a new thread ? shall I start new thread with the same name?