This edit is use when you have an existing dropdown list available and want to change to a new list.
Initially select the cell which contains the list (example C5)
Go to Data tab > Data Tools > Data Validation
Alternatively you could use a shortcut key ALT + D + L
Select Settings group > Allow > List > Source
Amend the source name to the new one and click OK
You can call us now on 020 3817 6945 or fill out the form below.