Initially, a worksheet containing a lot of resource info (dates, rates,
hours, etc, etc) was updated manually by one person and I am now slowly
trying to add in functions to automate as much as possible. To improve data
accuracy.

I have a column to identify if a resource is active/inactive and when a
resource becomes inactive, several columns require input, such as date left,
reason left, etc etc. There is a variety of columns to fill out when a
resource leaves.

When inactive, I would like to be able to check the impacted columns to see
if proper values have been entered. Is there a way to do this? If possible,
I would like to notify the person that is entering the data that they forgot
to update something.

I havent found a way to do this with excel functions, but perhaps in VBA?
I am just beginning to learn VBA but dont know enough about it yet.

Thanks for any help provided.