Macro/VBS to create entry...

[jtmoore]

Hello All,

Thanks in advance for any and all assistance!

I have a workbook which tracks the current status of jobs and then records the changes on a separate worksheet in the workbook.
Right now it is a time consuming process to enter the changes in the status log worksheet and then go enter them again in the change history worksheet.

I am wondering if there is a code that will allow the worksheet to automatically fill in an entry when something comes due.
In my attached sample workbook on the 'status log' the Job number 372 in the CA # column is set up to be due today.
We see in the 'what is due' column that corrective action is due.

I would like excel to automatically make an entry in the change history worksheet whenever a job becomes due.
The change history worksheet has a highlighted row showing how the output would look ideally.

I know nothing about code or vba so thanks for the assistance and pardon any ignorance on my part.

Sample Workbook.xlsm

Thanks,

JT

[jtmoore]

Any ideas anyone?