How to autoupdate a list when source data changes

[Susan_Boland]

Hi,

I would really appreciate if someone could help me with this problem:

I Have two lists on my worksheet:

List 1 is a selection for a calculation basis, the entries are "Manual" and "Automatic"

List 2 is dependent on the entries in List 1, as follows: =IF($A$1="Automatic",D2,Vendors), - - This syntax is entered in the List Source field of the data validation tab

Where:
A1 is the Output Parameter from List 1
D2 is the value to show is I want an automatic calculation
Vendors is the named range list to show if List 1 is set to "Manual"

The list syntax works for both lists, when I select Automatic, the correct value populated, when I select Manual, the correct range appears in the List field, however, the output parameter fro List 2 does not automatically update unless I select it and bring the range up.

Can someone help me figure out how to make the list auto update with the correct values for both Manual and Automatic?