I have the following XLS
A B C D E F G H
Forename Initial MiddleNames Surname Job Title Job_Family_desc NewGrade Comments
Paula P Edwards Job A AAA - Job Family A 0
Vin V Smith Job A CCC Job Family C 0
Jane J Lewis Job B BBB Job Family B 6
Sara S Jones Job B BBB Job Family B 6
Choe C Hill Job C BBB Job Family B 6

Its created by a macro that creates different New Grade validation lists dependant upon the job family.
This is fine if the job faily doesn’t change, but the user can change the job family to another one ut the NewGrade Validation list stays the same.

I want to create an on change macro that, If F changes recreates the calidation list for that file.
All I have for the moment is this

Please Login or Register  to view this content.
Which brings up a message box if A1 changes
But I need it do do this for the whole column (I have the macro for the conditional list section so this is fine)
If anyone has any ideas that would be great