Excel coding and formulas for master and cost sheets

Hi Suzi
Please see attached sample which should be self explanatory.
Master sheet would contain all the items to be used on the pricing sheet.
When you click on a cell in column A of the Pricing sheet it will display a list of all the codes contained on the master sheet. When you select one all the relevant price data will be read into the Pricing sheet.
Hope this helps.
Good luck.
Tony