Community archive

Ask something
Discussion Locked

Drop down list in excel 2003

0 helpful
2 replies

by andre.proulx2

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How to create a drop down list in excel 2003 in a sheet (invoice)from a workbook when the data base is in another sheet (inventory) of the same woorbook. Thank you

2 replies

by robertdeniro

Do you mean a validation dropdown?

Define your list as a named range. For instance 'MyList'.

In the list Source box type =MyList

by hdtreas

This works when the information is on the same worksheet. I can't find out how to access the information when it is on another worksheet in the same workbook.

This discussion is closed to new replies.