I have a book that contain two sheets (Costing & Accessories).
My Problem are
1.how to hide the duplicate data in Data Validation ?
In Costing sheet, in column B18:B31 use Data-Validation-List-Sourc
=AccCategory (range name for Accessories sheet column category)
Because Accessories sheet is a table data then may have a duplicat
data in Category field. How to hide the duplicate data and only sho
single data when in Data Validation ?

2. filter selection into another combobox
what I'm select in B18 then will filterlist into C18. e.g in B18 i
"Drawcord" then in C18 only show "Drawcord" data for user to select
When user select the data, all the other field like curr,qty,supplie
will get the data from the selected record of C18

Please advice and hel

Attachment filename: book3.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40558
--
Message posted from http://www.ExcelForum.com