Dynamic Data Validation from another sheet

[warreng]

Hi,

Is it possible to have a dynamic data validation drop down list in Sheet1 that references a dynamic range in sheet 2?

I couldnt figure it out. I know I can have a dynamic drop down list if the data validation cell and the dynamic range are in the same sheet because Ive tried it and it works. I did this by selecting my range and making it a table. I am using excel 2007.

Thank you.

[pb71]

Please see attached.

Formulas - Define Name (in the example = Dynamic2)

Refers to: =OFFSET(Sheet2!$A$1,1,0,COUNTA(Sheet2!$A:$A)-1)

On Sheet1 (in the example cell A2):

Data Validation - List - Source: =Dynamic2

[warreng]

That's perfect! much appreciated.

Cheers