Drop down list selections creating values in adjoining cell

W

WoodyAccess

I have managed to create a drop down list in my main workbook (named:
December) from a list (named: Wines) from another workbook (named: DataSheet)

What I want to happen is that when I select one of the items from the drop
down list (cell C8 in workbook December) a price automatically appears for
that item in the adjacent cell (D8).

I have written all the wine types in cells A1:A37 in DataSheet and all the
prices for the wines in the adjacent box in DataSheet B1:B37 (So the price
appears next to the wine)

How do I get these values to appear after just selecting one iten form the
dropdown box in workbook December

I am a novice/intermediate excel user so please so please could you explain
things in a simple way
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
How to make repeating drop-down lists? 2
Drop down lists in seperate columns 5
Formatted cell column in drop down list 1
Insert name and adress from a list in a word document 1
Word VBA - Automatic change content of a cell in table using dropdown list 5
Limit drop down items based on another cell 3
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6

Top