Check box and printing

[Twinjayhawks]

I need to create an order form.

The form will have company A and company B. Both companies will have different prices for each item that they sell. As I go through my inventory each week I need to create a form of things I need to order. I would like to check an item to order from the cheapest company... Then print out all of the items I need to order from each company.

Does anyone know if this is possible?

 

[iNotes4You]

Yes, it is possible.
In brief ...
Create a function containing an IF-Function for the cheapest price to insert in the order list.
Best practice would be to create two sheets. First sheet contains tables with prices for vendors A and B.
Second sheet contains the order list. Price fields of the order list are linked to the first sheet using IF-Function.

Edited by Moderator - no blog links, please read the forum rules.