Data VAlidation lists challenge

[lukiebabie]

Hi Guys

I have a worksheet with several different tabs. I have a data validation list on the front tab and the same list on each of the other tabs. I need my sheet to work so that a change made to any of the lists is refelected on all the other tabs?

I hope this is fairly clear to understand

Thanks for your help

[bonny24tycoon]

We understand.. Can you upload an example workbook so we could help you in a better way. Thanks.....

[lukiebabie]

In the sheet below the same data validation lists appear on both Tab1 and 2.

I want to be able to change one of the lists options, and those changes to also happen on the second tab.

List problem example.xlsx

Cheers

[bonny24tycoon]

Why dont we just link both sheets instead of a validation on Sheet2, like this?? List problem example.xlsx

[lukiebabie]

I need the lists on both tabs to be dynamic. The example I have given here is a very simple version of what I am wroking with. On my actual worksheet there are many tables and graphs on each tab.

Do you know of any way that this can be done?

Cheers

[bonny24tycoon]

Hi There,

Im not sure of any formulae's.. I tried to achieve this by some macros..


Can you check if this is something you need?? List problem example.xlsx

[lukiebabie]

Ok. If there is no way to do this then I will use the first option you put forward.

This was not essential to the worK I am doing but it was a "very nice to have".

THanks for your help