Note: i have enclosed a file. Two worksheets in the file. "Sheet1" is the worksheet were data is entered. Worksheet="DataSelections" is where i identify item and its corresponding cost.
On Sheet1 i want someone to select an item from a dropdown list........which i have done using datavalidation.
After an item is selected i want the associated cost of this item (which you can get from the worksheet "DataSelections") to be automatically put into column B(cost column) on sheet1.
I am not sure the best way to make this happen?
Anythoughts.
Bookmarks