Cost - Margin (not markup!) - Selling Price - Profit
In creating this spreadsheet we need to have the ability to input values into each cell, ie - if we want to sell certain items at a certain margin, or we want to make X amount of profit on certain items. I'm a lumber and builing material salesman, so the sku's will be in the 400-500 item range - starting with a master last so each salesman can and manager can use. Every item will need to be individually manipulated.
Once the quote is finished we will then need to print the quote showing only those items being quoted with quantities. Those items that have a 0 qty need not be printed.

any help would be greatly appreciated!