Drop down menu via different tab?

[droo09]

So I want to make a dropdown box that is filled from a list on a seperate tab. The data is straight forward; single column that goes straight down. Help please

 

[Jonmo1]

You have to use a named range...

On the seperete tab, highlight the range of data and click Insert - Name - Define
Give it a name like MyRange or whatever

Then in Validation on any other page, you can use
=MyRange


Hope that helps.