V
vcff
Hi All
I had 2 worksheets as follow:
Sheet1 contains hundreds of products name, product serial nos, cost, selling
price, date of purchase, etc.
I had name the range of products name as name.
In Sheet2, using data validation dropdown list, , whenever I select one
product, I want certain info to be displayed in the cells I had intended to.
e.g.
A1 when "Rod" was selected from dropdown list,
to display automatically the related info as follow:
C1 to display the date of purchased,
D1 to display serial number,
B4 to display selling price
Thanks
I had 2 worksheets as follow:
Sheet1 contains hundreds of products name, product serial nos, cost, selling
price, date of purchase, etc.
I had name the range of products name as name.
In Sheet2, using data validation dropdown list, , whenever I select one
product, I want certain info to be displayed in the cells I had intended to.
e.g.
A1 when "Rod" was selected from dropdown list,
to display automatically the related info as follow:
C1 to display the date of purchased,
D1 to display serial number,
B4 to display selling price
Thanks