Validation or define problem

Hi
I again posted my question
I have two workbook with one unique header(i.e) supplier name
One workbook is supplier name
another workbook is Inventory
But bot of workbook one coloumn is same which is supplier name
I wanted if i add or feeding in inventory it will automatically detect the supplier name which i define in suplier sheet of supplier workbook

Thanks
chacha

Thanks Sir for your reply
I CHECK THE FILE AND YOUR REPLY..

What i need, I again attached the file and give you format of what I need.
Basically i need in Inventory you find the Supplier NAME in Inventory workbook. i need that it Automatically detect the supplier name (i.e)cocacola, KandNfood,which i creat the group and define the product name.

Thanks for your cooperation Sir

thank you very much

CHACHA