data validation problem

hi all
i am in perfumery business. every day i am receiving all chemicals price list. plz help me to reduce my work load through excel. below are the scenario:-
I am having 1000 chemicals list ( let us call it master chemical list). and for creating particular fragrance i need to select 30 chemicals from master chemicals list.like that i need to create 200 no.s of fragrance per day. and every day master chemical list price will change.
My problem is:-
i already created dropbox data validation option for 200 no.s of fragrance now i need to find per fragrance price list. fragrance formula list are in different sheet and master chemicals price are in different sheets.
when i select particular fragrance name then it will automatically show all the chemicals name which i use to create particular fragrance.
in master chemical list every day i need to create new date in cell and below that i need to type current date price value.
i need that price list of particular fragrance to display in same page where perfumery formula are showing.
plz help it.

change your topic title according to the forumrules.

Royalshah please stop posting duplicate threads. I will close this one plus all the others - you may continue on this 1...
http://www.excelforum.com/excel-form...n-problem.html