Hi.
I have a spreadsheet where the user selects a product from a dropdown list.
this list is connected to a vlookup that produces a cost (in another cell)
based on the product chosen.
I want the user to be able to update the price list by simply entering a new
price for that product into the cost cell & then have excel save the newly
entered cost back to the worksheet that contains all of the costings.
Is this possible?
Can you help???

Thanks :)