Worksheet Change help: do not show validation list (Column D) if column A is blank

All,

I have a spreadsheet that basically tracks my current job alerts. See attached.

In column A, I have job descriptions, and in column D, I have what type of jobs I'm applying for (via a simple data validation list).

All works OK, except that I cannot work out the Worksheet change adaption that is needed for the following scenario:

If there is NO input in Column A, Column D can still be shown....e.g. the validation list in column D can still be seen but that should not be possible as there is no job description in column A!!!


Please find attached file and the error which is highlighted in red.

Hope you can help.

Skyping

Check out if such supplement to your WorksheetChange will do:

Please Login or Register  to view this content.

Note, that it deletes column D also if there was something in column B before, but it was deleted later on.