Data validation

[ccameron]

I am trying to do a list with a drop down box, I can get it to work if the data is on the same sheet as the drop down box, but would like to be able to get the data from another sheet, can antone help me please?

 

[Matty]

Hi,

If you want to pull data from another Worksheet, you have to name the range and point the data validation to that named range.

Post back if you want to know more about named ranges.

Matty

 

[ccameron]

Thanks but not sure how to do it.

 

[ccameron]

Its ok I worked it out, thank anyway

 

[Peter_SSs]

Edit: Sorry, hadn't seen your last reply.

On the sheet that has the list of values ...

1. Select the list of values.

2. In the Name Box (white box just above the top left of the column labels) type:
myList
and then press Enter.

On the sheet where you want the Data Validation drop-down ...

3. Select the Cell where you want the drop-down.

4. In the Data Validation dialog:
Settings tab|Allow: List|Source: =myList|OK