Hi, this is my first post and I am struggling to find a way to link 2 of the exact same data validation lists on two seperate worksheets. For example worksheet one has data and figures for specific regions, and worksheet two provides these figures in a graph, however I would like to link these two worksheets and so if the list is changed in worksheet 1, this will automatically change in worksheet 2 and vice versa. Is this possible? Thanks
Bookmarks