Pull Down Menu

[aiyathomas]

Hi .. How can I make the list of the Pull Down Menu from a column of a different sheet? Once I added a new row from the sheet and it will automatically show in the Pull Down Menu. Thanks.

[BadlySpelledBuoy]

Create the list using a "Dynamic Named Range".

For example if your list of data was on Sheet2 starting in cell A1 the formula for the named range would be:
=Sheet2!$A$1:INDEX(Sheet2!$A:$A,COUNTA(Sheet2!$A:$A))

Then set up the data validation using this named range and it will expand/contract as you add/remove values from the list.

Data validation in the attached is set up on the yellow cells on Sheet1. List is stored on Sheet2. Press Ctrl+F3 to bring up the name manager box to see the formula.

Hope that's of help.

BSB