Hi Guys,

I'm a complete noob when it comes to VBA programming in excel and was wondering if someone could help me with a problem I'm having.

I have a task/issue tracking sheet that I use to manage my day to day workload. The sheet has a task due date column. Sometimes for whatever reason some dates pass before the item is complete and I would like it if these past dates auto updated (on workbook open) to todays date.

I've given it a go but have failed so far.

Can anyone help?

Cheers

Sam