drop down menus

[mark gardner]

I can create a drop-down menu from a list. I want to pull the drop down to another page so that it will reference the list on the first page. Is this possible?

 

[MarkAndrews]

To my knowledge Validation lists only work, providing the list is present on the sheet tab where the Validation is to be placed

 

[njimack]

To my knowledge Validation lists only work, providing the list is present on the sheet tab where the Validation is to be placed

Not true. Simply define a named range which houses your validation list.
Then set up your validation to reference the named range

 

[MarkAndrews]

To my knowledge Validation lists only work, providing the list is present on the sheet tab where the Validation is to be placed

Not true. Simply define a named range which houses your validation list.
Then set up your validation to reference the named range

I had problems with this last wee Neil

My (named) range was on another worksheet in the same workbook

I tried to validate, using the range & it didn't have it? (or work)

Using Excel 2000

 

[njimack]

ADVERTISEMENT

My (named) range was on another worksheet in the same workbook

I tried to validate, using the range & it didn't have it? (or work)

Are you sure you entered the range name into the validation criteria correctly?

In the source box, the formula should read =Rangename

Don't include any quote marks, apostrophe's etc.

 

[MarkAndrews]

My (named) range was on another worksheet in the same workbook

I tried to validate, using the range & it didn't have it? (or work)

Are you sure you entered the range name into the validation criteria correctly?

In the source box, the formula should read =Rangename

Don't include any quote marks, apostrophe's etc.

Positive, It caused me a days worth of problems......

 

[Norie]

Mark

What exactly did you do?

I agree with Neil, this is possible.

 

[MarkAndrews]

Mark

What exactly did you do?

I agree with Neil, this is possible.

OK, pls excuse the short explanation

3 worksheets
sheet1 has a list, this was named (as in named range)
sheet2 - A1, data > validation > list > =namedrange

And it didn't work?

Eventually I had to put the list on the same sheet as the validation

???