Hi Sara

You don't need Data Validation for a drop down list in this scenario.
You need Autofilter.
Highlight cells A1 and B1, DataFilterAutofilter
Choose the dropdown on column B and select OK
This will give a filtered list of the rows where column A data is
correct.

If required, you can mark the filtered range of Rows, Copy and then
Paste to another location.

--
Regards

Roger Govier


"Sara Hopkins" wrote in message
...
Hi
I have a worksheet that contains legacy data that is being cleaned to
conform to specific formats and conventions. I have another worksheet
that
uses this cleaned data to build a new database row. I want to put a
drop
down list in my database row worksheet that lists only the cleaned
data.

For Example
Column A is the data to be cleaned
Column B contains a formula that tells the end user that the data is
OK or
what about the data needs to be cleaned.

ColA ColB
AA12 OK
aa13 Clean Letters
BB03 OK
CC4 Clean Numbers

So my drop down list must contain the content of ColA where the
content of
ColB = OK i.e. AA12 and BB03.

I've tried using Debra Daglish's Dependant Drop Down Sorted Lists
solution (
http://www.contextures.com/xlDataVal13.html ) with the formula changed
so
that the column goes to the left by 1, but as you can see, ColA has
the sort.
I get AA12 and aa13 in my drop down list.

I have considered using Debra Daglish's Create Dependant Lists
solution
using the INDIRECT function, but if I understand it, every distinct
occurrence in ColB's would have to have it's own named range. I can
see that
solution getting rather cumbersome.

Can anyone suggest a solution?

TIA