Forum Discussion
Refresh Drop-down list
Hi
I'm afraid it is not very clear what you want? Can you attach a sample?
Do you have 2 lists - a master and an other that you want to somehow switch between them. Or do you have several lists held on a 'master' sheet and you want to switch between those? if that is the case what is the test that needs to apply to change from say List 1 to List 2 or List 3 etc.
If you can attach an example that often makes it easier to understand.
thanks
Peter
Hello, Peter,
I have a master list. All important data is stored in master list.
In the other Excel-Sheets A and B there are dropdowns that draw their data from the master list.I now select the data for Excel sheets A and B using the drop-down menu.
The data was transferred into the cell.Suppose I want to change the data from the cells on Excel sheets A and B now.
For this I go to the master list and change the data from the master list.Now I want the data in the cells on Excel sheets A and B to be changed automatically.
Until now, the old data in the cells on Excel sheets A and B remain. To achieve the change, however, you have to select the changed data again using the drop-down menu.
Is there a solution for my wish?
warm greetings
Hi Lukas,
In the attached the 'master' sheet has a list X, Y, Z.
In the main sheet you select from the drop down the value you want - as an example X.
If I understand your issue you want to change the drop down from X,Y,Z to A,B,C?
You ,of course, can do this. On the main sheet the X will remain until you select one of A,B or C.
Excel has no way of changing X because there is no way of knowing if you want A,B or C until you select.
Sorry!
Peter
- Is there any way to refresh a drop down list with the first element of the list?
In this example X will remain, but is there any way to said excel pick the first element by default?
