I have a customer list sheet and a customer work sheet. I am using the name of the customer from the customer list sheet in the customer work sheet as drop-down using valid if function as shown in the picture below.
The issue is when I change/update the name of the customer in the customer list sheet, it doesn’t automatically update the used name in the customer work sheet by itself. I have to go edit it and then it shows to change.
Please help me to resolve it!