Hi, I work as a sales engineer in a company. We have lot of pricelist in hard copy we got from the supplier. Each time, we do a quotation for the customer we have to refer to the hard copy pricelist and key in the price after mark-up (in perecentage). I would like to have a excel spreadsheet that when i can key in the partno/model no and the percentage of mark-up it will automatically calculate the mark-up price for me. At the same time,it will also create a costing sheet in another sheet within the same spreadsheet. Pleas advise how it can be done.