Sort

I have the attached supplier database table where there are
i) some basic info like his co. name, location, contact details (there can be more field like fax no., email id and so on)
ii) The items they manufacture

I want to insert a item (for example "Cable') in a new sheet of the same excel, and it should show all the suppliers of Cable (row-wise display) with there basic details (column wise respective to that row) as mentioned in the master excel sheet.

In actual case, the master sheet consists around 500 rows of supplier name (just for information).

Please help.

I don't want same supplier name & all the basic details to be written again and again,for all items it can supply. Duplicate supplier name in master database doesn't look good. You may resolve my query considering the supplier master table, I have provided. I am also open for suggestions where I can create the master database in some other way (except the one you suggested) if it solve my purpose.