Good morning I am having some issues in achieving a solution to the following problem:
I have multiple worksheets which provide me with different views of essentially the same data. I would like to be able to select from a number of different parameters through drop down lists on each individual worksheet. I am able to populate these drop-down lists but I would also like to achieve that once I select entry "ABC" on e.g. "worksheet 1 drop down list 2", that the corresponding (e.g. same) "worksheet 2 drop down list 2" is updated to "ABC" In other words, I would like to create a "Global Drop Down List" which I can use multiple times and which all link back to a single cell. Is that possible and could anyone point me in the right direction? Thanks in advance Regards, Reto -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
