Hi
Have a look at the sample Workbook attached. If you click on cell B2 in Sheet One and select an item, the unit cost will be automatically populated according to the selected item.
If this is what you want let me know and I will explain how it is achieved.
Tony
|