I have a log which several of my staff enter information into daily. They generally work Monday through Friday; however, sometimes work weekends. Therefore, I need the log to be inclusive of all dates from log's origin forward (9/21/12-current).

I am struggling to create a VBA code which would add new row(s) to the top of the log from the last date entered to today's current date, maintaining all formatting then adding the date to the appropriate cell. I need the workbook to update automatically when opened as these users are inexperienced with excel.

The column headers are in rows 1-3. The dates are in column B and begin in cell B4. The data within the table begins in cell C4.

Any help is greatly appreciated. Thank you!