Notthekingofexcel
New Member
- Joined
- Oct 13, 2014
- Messages
- 10
Hi,
I have a dropdown list on one sheet. I want to be able to see that dropdown list on multiple sheets. I also want to be able to change the dropdown list from any of the sheets and this change effects all the related dropdown lists in the workbook.
I know that I could use an INDIRECT, but that would not allow me to change it from that sheet I would have to go back to the original.
Is this possible?
Thanks,
Oliver
I have a dropdown list on one sheet. I want to be able to see that dropdown list on multiple sheets. I also want to be able to change the dropdown list from any of the sheets and this change effects all the related dropdown lists in the workbook.
I know that I could use an INDIRECT, but that would not allow me to change it from that sheet I would have to go back to the original.
Is this possible?
Thanks,
Oliver