Excel Macro to add rows until today's date and update following columns accordingly

I got an excell sheet with 3 worksheets that I update like every 2-3 days manually by dropping down the date column and it automatically updates the columns based on the date. For example; lets say I opened the excel on april 4th what I do is I drop down the date and until today -1 and following columns gets updated automatically. I basically add in 2 more rows to the worksheet and and columns get updated based on the date. 01.04.2016 12 15 16 19

I would like to make a macro which adds in those needed rows (If i no one updated the excel for like 10 days it needs to add in 9 rows etc) when I hit the button for 3 worksheets at once.

Thanks alot.

Recent Questions...