How to automatically update data from data validation lists

[Milkyway]

Hi,

I'm building an Excell 2007 workbook which has some data validation lists in the first worksheet ("lists"). These are standard statments and values which will be updated/changed from time to time.

Then there are multiple worksheets (100+) with the same layout but containing variable info, some of which will be populated via drop down boxes, using the info from the data validation lists.

Ideally if I change a standard statement/value in the "lists" worksheet it would automatically update the field, not just the options in the dropdown box, where ever it is selected in all the reamining worksheets.

I have seen some solutions for one list and one worksheet, but I'm new to code so I'm not sure how to expand this to multiple lists and multiple worksheets.

Thanks

 

[villy]

I don't really get what you mean but maybe this will help...

In the data validation click list then in source type in without the quote:
"=OFFSET(nameofsheet!$A$2,0,0,COUNTA(nameofsheet!$A$2:$A$999),1)"
Note: Number in red can be changed to suit your range
$A$2:$A$999 is where your data were stored


Any comments are welcome

Thanks