Massivebarra
New Member
- Joined
- Jun 13, 2018
- Messages
- 4
hi,
I have multiple suppliers that I ask them to supply plumbing items that I choose at their best price.
My trouble is the suppliers are becoming more eg. 10 suppliers.
Each supplier can supply their 'own brand' of tap or Pipe
Each supplier may have a different QTY for what they are offering at price.
i want to be able to locate the best price for an item and then somehow order from the spreadsheet without revealing a competitors price to them
I hope this makes sense?
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]ITEM[/TD]
[TD]SUPPLIER 1[/TD]
[TD]QTY[/TD]
[TD]SUPPLIER 2[/TD]
[TD]QTY[/TD]
[TD]SUPPLIER 3[/TD]
[TD]QTY[/TD]
[TD]SUPPLIER 4[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TAP[/TD]
[TD]$3.10[/TD]
[TD]1000[/TD]
[TD]$3:30[/TD]
[TD]500[/TD]
[TD]$2.70[/TD]
[TD]2000[/TD]
[TD]$3.20[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]PIPE[/TD]
[TD]$10.00[/TD]
[TD]100[/TD]
[TD]$10.50[/TD]
[TD]200[/TD]
[TD]$11.00[/TD]
[TD]100[/TD]
[TD]$10:00[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]CU[/TD]
[TD]$30.50[/TD]
[TD]50[/TD]
[TD]$30.20[/TD]
[TD]50[/TD]
[TD]$31.00[/TD]
[TD]50[/TD]
[TD]$25.50[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]FITTING[/TD]
[TD]$5.00[/TD]
[TD]100[/TD]
[TD]$5.00[/TD]
[TD]100[/TD]
[TD]$5.00[/TD]
[TD]200[/TD]
[TD]$5.50[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]GLUE[/TD]
[TD]$3.70[/TD]
[TD]60[/TD]
[TD]$4.00[/TD]
[TD]50[/TD]
[TD]$3.70[/TD]
[TD]100[/TD]
[TD]$3.70[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]VENT[/TD]
[TD]$8.10[/TD]
[TD]100[/TD]
[TD]$5.00[/TD]
[TD]200[/TD]
[TD]$8.10[/TD]
[TD]100[/TD]
[TD]$7.50[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]
I have multiple suppliers that I ask them to supply plumbing items that I choose at their best price.
My trouble is the suppliers are becoming more eg. 10 suppliers.
Each supplier can supply their 'own brand' of tap or Pipe
Each supplier may have a different QTY for what they are offering at price.
i want to be able to locate the best price for an item and then somehow order from the spreadsheet without revealing a competitors price to them
I hope this makes sense?
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]ITEM[/TD]
[TD]SUPPLIER 1[/TD]
[TD]QTY[/TD]
[TD]SUPPLIER 2[/TD]
[TD]QTY[/TD]
[TD]SUPPLIER 3[/TD]
[TD]QTY[/TD]
[TD]SUPPLIER 4[/TD]
[TD]QTY[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]TAP[/TD]
[TD]$3.10[/TD]
[TD]1000[/TD]
[TD]$3:30[/TD]
[TD]500[/TD]
[TD]$2.70[/TD]
[TD]2000[/TD]
[TD]$3.20[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]PIPE[/TD]
[TD]$10.00[/TD]
[TD]100[/TD]
[TD]$10.50[/TD]
[TD]200[/TD]
[TD]$11.00[/TD]
[TD]100[/TD]
[TD]$10:00[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]CU[/TD]
[TD]$30.50[/TD]
[TD]50[/TD]
[TD]$30.20[/TD]
[TD]50[/TD]
[TD]$31.00[/TD]
[TD]50[/TD]
[TD]$25.50[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]FITTING[/TD]
[TD]$5.00[/TD]
[TD]100[/TD]
[TD]$5.00[/TD]
[TD]100[/TD]
[TD]$5.00[/TD]
[TD]200[/TD]
[TD]$5.50[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]GLUE[/TD]
[TD]$3.70[/TD]
[TD]60[/TD]
[TD]$4.00[/TD]
[TD]50[/TD]
[TD]$3.70[/TD]
[TD]100[/TD]
[TD]$3.70[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]VENT[/TD]
[TD]$8.10[/TD]
[TD]100[/TD]
[TD]$5.00[/TD]
[TD]200[/TD]
[TD]$8.10[/TD]
[TD]100[/TD]
[TD]$7.50[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]