Search for empty cells in row and enter data in last column when the row is full

Hello,

i am fairly new to writing any kind of code. i have a simple table that has columns A, B, and C with constant data. Columns D:P are blank but have a list to choose from when the task is complete. in Column Q i have an If formula to determine if cells D:P are blank and if all are not blank it returns "Ready". I have code written in VBA that creates a time-stamp in Column R when data is entered, it works great if i manually add data to Q. My problem is that the formula doesn't change the contents of the cell and i would like it to automatically update my time-stamp when all of my tasks are complete. My thought was using an "If ElseIf Then" but i couldn't make it work for me. i have tried for 3 days to do this, i know there has to be a way. If it would help to load screen shots or something let me know. Please help me as this is turning my hair even more gray than it already is. Thanks in advance!

-John

If it would help to load screen shots or something let me know.

Please don't load pictures; they're next to useless. Upload a sample workbook with some typical data. Indicate the input, process and expected output.


Regards, TMS