Validation or define problem

[chacha]

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