looking for a faster 'find in column' method

[rmar2011]

I have two worksheets, one called 'data collection' and one called 'first run.' I have code that loops through each value in 'first run' to find the value in 'data collection' (if it's there) and when it is it copies the cell that's two columns over into 'first run'.

The problem is that when I run it there can be upwards of 500 values to look through and it takes awhile. Is there a faster way than the way I have? Maybe a function or something?

Here's my code:

Please Login or Register  to view this content.

I already have Application.Screenupdating false and everything.
Thanks!

[efernandes67]

Hi,

Post your file and give an example.

Elio Fernandes

[Andrew-R]

How about this:

Please Login or Register  to view this content.

[rmar2011]

Andrew-R that was so much faster. Thanks a lot!