Need some help with what I "think" are VBA codes. I have two lists: List 1 and List 2. List 2 is accessed in cell C15 is set up as a dependent of List 1. For example, I make a choice from a drop down in List 1 and the selections available in List 2 are affected.

List 1 (located in cell C14) contains a list of six options. If Options 1 - 4 are selected in cell C14, I want cell C15 to show "N/A." If Options 5 and 6 are chosen, I want C15 to allow two different dependent lists to be available.

Further more, I would love for cell C15 to be left blank if C14 is blank.

So I guess the logic would be something like this...
A. If C14 is blank, then C15 should also be blank.
B. If C14 is selected as Options 1 - 4, then C15 should show "N/A."
C. If C14 is selected as Option 5, then C15 should show the Option 5 dependent drop down list.
D. If C14 is selected as Option 6, then C15 should show the Option 6 dependent drop down list.

One additional note, it would be great if, when a change is made to C14, cell C15 changes per the logic in A-B no matter how many times I make a change. For example, I choose Option 4 in C14 and C15 shows "N/A." I then change C14 to Option 5 and don't want "N/A" to remain in C15. ( I hope this makes sense.)

I have seen a few codes listed in this forum for others, but when I try to copy and make the necessary reference changes, nothing happens.

Can anyone help me with this?

Thanks,
Chris