Hi,
column B in another sheet?, could you post an example on how your data looks
like and what do you want to get, thanks

"Katerinia" wrote:

I need to basically widdle away data in a worksheet, using the criterial of
same codes. Col A is the full list of codes followed by data relating to it.
I dont need all these rows of data, i only need the data that correlates
wtih matching codes from a shorter list currently in Col B.

"Katerinia" wrote:

COL of codes in A (full List of codes of about 2,000)
COL of codes in B (selection of COL A codes of about 850)

IF COL B code matches COLUMN A code, then true, else false