Dynamic list creation

Hi all,

I work with several suppliers, all of them give me different prices for the same item, and I use to order to the cheapest one. I use to compile all data in one sheet constructed as below:

column A : generic item description
column B : unit size
colume C / D / E / F : corresponding prices of supplier # A , B, C, D.
column G : lowest price of the 4 suppliers
Column H : user needs to enter the quantity he requires

What I would like, is to create in separate tabs (number of tabs = number of suppliers), "dynamic list" that is self-generated from suppliers that has cheapest prices.

You will find the example of what I am looking for in the enclosed XLS file !
If possible I would like to avoir VBA.

Thank you for your help !!
dynamic list example.xlsx

Thanks for your answer fotis1991,
but that is not quite what is was looking for,

I would like to populate the other tab (suppliers A/B/C/D) with content of the master table (tab" order list), depending on a row criteria, in my example, the lowest price, column G ( i am working on my side for a solution with a filter... but cannot acheive perfect result either..)
Thanks you !
have you got a idea ?

Thanks Fotis1991,
there's many files other there, not sure which one to pick-up...

Hi,



i have did necessary changes in this below file . i have created 4 pivot Tables each Table for each Supplier on sheet no 1.hope it will solve your problem.
dynamic list example.xlsx

Hi Md Aejaz,

Thank you for your helps,
It indeed seems to be the best solution for what I'm looking for !
perfect
thanks and have a good day !