Cell Content Editing via DropDown List

[keeyu]

Hello

I am working on a excel file about stock-keeping.

My excel file has two sheets. The first sheet's column A has a list of vendor names.

The second sheet keeps a list of item details. Each row corresponds to one item, and each column corresponds to one attribute (such as color, style, price)

In particular, one attribute is the vendor. Clearly, it can only take values from the column A in the first sheet.

I would like the following effect: when I am editing the second sheet, whenever I am entering the vendor field, a drop down list box will appears for me to pick a vendor. Naturally, the vendor names of the drop down list is from column A of first sheet.

Is it possible to do this?

THanks.

 

[PaddyD]

keeyu

welcome to the board.

What you want is:

(a) easy
(b) called data validation.

What you do is set up the range of cell with data validation (Data | Validation). Set the validation to allow a list, then source the list from your 'master' list of vendors.

Paddy