Cell Content Editing via DropDown List

keeyu

New Member
Joined
Aug 21, 2002
Messages
1
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.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
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
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top