I have two worksheets, Worksheet A and Worksheet B.
In Worsheet B, I have two columns. In the first column I have list of records all unique in value. In the second column thy are have value that defines a type of record for the first column and contains values like R, N, P, T.
In Worksheet A, I want to create a Data Validation list from the records in Worksheet B where the values listed in first Column are equal to the value R from the second columns.
Also using MS Excel 2003
=WKSheetB!$L$10:$L$439 where WKSHeeTB!$M$10:$M$439=R
I know this is no way close to right but any help be greatly appciated.